Lessons

Introduction to Excel

• 1: Setting Up Your Excel Environment
• 2: Starting a Workbook
• 3: Modifying Columns, Rows, & Cells
• 4: Formatting Text
• 5: Creating Simple Formulas
• 6: Working with Cells
• 7: Printing Workbooks

Excel Basics

• 8: Creating Complex Formulas
• 9: Working with Basic Functions
• 10: Sorting, Grouping, and Filtering Cells
• 11: Formatting Tables
• 12: Aligning Text
• 13: Working with Worksheets

Doing More with Excel

• 14: Using Templates
• 15: Using What-If Analysis
• 16: Working with Charts
• 17: Using Conditional Formatting
• 18: Creating Pivot Tables