Excel 2010 Essential Training

Excel tutorials that use real-world examples to teach the core features and tools in Excel 2010.

Introduction

• Welcome
• Using the exercise files

1. Getting Started

• Exploring three common uses for Excel
• Touring the interface
• Finding the commands you need
• Using Backstage view or the File tab
• Maintaining file compatibility

2. Worksheet Basics

• Creating a worksheet
• Techniques for copying and pasting
• Entering data automatically with Auto Fill
• Targeting large data groups
• Changing a worksheet's structure

3. Excel Formula Basics

• Understanding formulas and functions
• Entering data in a worksheet
• Adding numbers manually
• Adding numbers using Sum and AutoSum
• Adding a whole worksheet
• Working with numbers in columns
• Preventing errors using absolute references
• Working with times and dates
• Using IF
• Using SUMIF and AVERAGEIF
• Naming and using cell ranges

4. Essential Formatting

• Formatting numbers and dates
• Applying fonts, background colors, and borders
• Adjusting columns, rows, and text
• Using conditional formatting
• Using custom conditional formatting
• Adding pictures and shapes

5. Advanced Formatting

• Inserting SmartArt
• Coordinating a look using themes
• Applying built-in styles
• Creating and sharing styles
• Using templates
• Creating and using original templates

6. Printing Preparation

• Making the pieces fit
• Inserting headers and footers
• Printing and PDFs

7. Large Excel Projects

• Finding and replacing data
• Freezing panes
• Repeating row and column titles
• Creating multiple custom worksheet views
• Hiding or grouping rows and columns
• Managing worksheets
• Calculating formulas across worksheets

8. Collaborating with Others

• Importing and exporting data in Excel
• Setting workbook permissions
• Inserting and editing comments
• Sharing a workbook
• Tracking changes
• Saving files in shared locations

9. Exploring Excel's Database Features

• Splitting cell data into multiple cells
• Joining data from multiple cells
• Basic and multi-field sorting
• Using tables to sort and filter data
• Inserting automatic subtotals
• Creating lookup tables

10. Analyzing Data

• Using auditing to diagram
• Using evaluation in Excel
• Working with Goal Seek
• Using data tables in formulas
• Using scenarios in formulas
• Exploring the Analysis ToolPak

11. Advanced Analysis with PivotTables

• Discovering PivotTables
• Creating a basic PivotTable
• Modifying a PivotTable
• Creating and modifying a PivotChart

12. Creating and Using Charts

• Choosing chart types
• Inserting Sparklines
• Creating a column chart
• Modifying a column chart
• Creating and modifying a pie chart
• Placing Excel charts into other Office applications

13. Creating and Using Macros

• Understanding macros
• Recording and using a simple macro
• Editing a macro

14. Customizing Excel

• Customizing the Quick Access toolbar
• Customizing the Ribbon bar
• Setting Excel options

Conclusion

• Goodbye