Lesson One: The Fundamentals

1. Starting Excel
2. Understanding the Excel Program Screen
3. Using Menus
4. Using Toolbars and Creating a New Workbook
5. Hiding, Displaying, and Moving Toolbars
6. Filling Out Dialog Boxes
7. Keystroke and Right Mouse Button Shortcuts
8. Opening/Saving a Workbook
9. Moving the Cell Pointer
10. Navigating a Worksheet
11. Entering Labels in a Worksheet
12. Entering Values in a Worksheet and Selecting a Cell Range Calculating Value Totals with AutoSum
13. Entering Formulas
14. Using AutoFill
15. Previewing and Printing a Worksheet
16. Getting Help from the Office Assistant
17. Changing the Office Assistant and Using the What's This? Button
18. Closing a Workbook and Exiting Excel

Lesson Two: Editing a Workbook

1. Entering Date Values and Using AutoComplete
2. Editing, Clearing, and Replacing Cell Contents
3. Cutting, Copying, and Pasting Cells
4. Moving and Copying Cells with Drag and Drop
5. Collecting and Pasting Multiple Items
6. Working with Absolute and Relative Cell References
7. Using the Paste Special Command
8. Inserting and Deleting Cells, Rows, and Columns
9. Using Undo, Redo, and Repeat
10. Checking Your Spelling
11. Finding and Replacing Information
12. Advanced Printing Options
13. File Management
14. Inserting Cell Comments

Lesson Three: Formatting a Worksheet

1. Formatting Fonts with the Formatting Toolbar
2. Formatting Values
3. Adjusting Row Height and Column Width
4. Changing Cell Alignment
5. Adding Borders
6. Applying Colors and Patterns
7. Using the Format Painter
8. Using AutoFormat
9. Creating a Custom Number Format
10. Creating, Applying, and Modifying a Style
11. Formatting Cells with Conditional Formatting
12. Merging Cells, Rotating Text, and using AutoFit

Lesson Four: Creating and Working with Charts

1. Creating a Chart
2. Moving and Resizing a Chart
3. Formatting and Editing Objects in a Chart
4. Changing a Chart's Source Data
5. Changing a Chart Type and Working with Pie Charts
6. Adding Titles, Gridlines, and a Data Table
7. Formatting a Data Series and Chart Axis
8. Annotating a Chart
9. Working with 3-D Charts
10. Selecting and Saving a Custom Chart
11. Using Fill Effects
12. Mapping Data
13. Modifying a Map

Lesson Five: Managing Your Workbooks

1. Switching Between Sheets in a Workbook
2. Inserting and Deleting Worksheets
3. Renaming and Moving Worksheets
4. Working with Several Workbooks and Windows
5. Splitting and Freezing a Window
6. Referencing External Data
7. Creating Headers, Footers, and Page Numbers
8. Specifying a Print Area and Controlling Page Breaks
9. Adjusting Page Margins and Orientation
10. Adding Print Titles and Gridlines
11. Changing the Paper Size and Print Scale
12. Protecting a Worksheet
13. Hiding Columns, Rows and Sheets
14. Viewing a Worksheet and Saving a Custom View
15. Working with Templates
16. Consolidating Worksheets