Lesson 1: Entering Text and Numbers

  1. The Microsoft Excel Window

  2. Moving Quickly Around the Microsoft Excel Worksheet

  3. Selecting Cells

  4. Entering Data

  5. Editing a Cell

  6. Changing a Cell Entry

  7. Wrapping Text

  8. Deleting a Cell Entry

  9. Entering Numbers as Labels or Values

  10. Smart Tags

  11. Saving a File

  12. Closing Microsoft Excel

Lesson 2: Formatting Text and Performing Mathematical Calculations

  1. Choosing a Default Font

  2. Adjusting the Standard Column Width

  3. Cell Alignment

  4. Adding Bold, Underline, and Italic

  5. Changing the Font, Font Size, and Font Color

  6. Working with Long Text

  7. Changing a Single Column Width

  8. Moving to a New Worksheet

  9. Setting the Enter Key Direction

  10. Making Numeric Entries

  11. Performing Mathematical Calculations

  12. The AutoSum Icon

  13. Automatic Calculation

  14. Formatting Numbers

  15. More Advanced Mathematical Calculations

  16. Cell Addressing

  17. Deleting Columns

  18. Deleting Rows

  19. Inserting Columns

  20. Inserting Rows

  21. Creating Borders

  22. Merge and Center

  23. Adding Background Color

  24. Using Auto Format

  25. Saving Your File

  26. Closing Microsoft Excel

Lesson 3: Numbers and Mathematical Calculations

  1. Reference Operators

  2. Functions

  3. Typing a Function

  4. Calculating an Average

  5. Calculating Min

  6. Calculating Max

  7. Calculating Count

  8. Filling Cells Automatically

  9. Saving Your File

  10. Closing Microsoft Excel

Lesson 4: Cool Stuff

  1. Data Entry Validation

  2. Sorting Data

  3. Filter Data

  4. Data Entry Forms

  5. Lookup Formulas

  6. VLOOKUP

  7. HLOOKUP

  8. LOOKUP

  9. Autoformat a Worksheet

  10. Transpose Rows

  11. Create Labels

  12. Freeze Panes

Lesson 5: Creating Charts

  1. Creating a Column Chart

  2. Changing the Size and Position of a Chart

  3. Modify Your Chart

  4. Saving Your File

  5. Closing Microsoft Excel

Lesson 6: Printing

  1. Page Breaks

  2. Page Setup

  3. Preview

  4. Print 

Keyboard Shortcuts

  1. Adding Sheets, Rows and Columns

  2. Resizing Rows and Columns

  3. Selecting Cells

  4. Moving and Copying Cells