Basic

Lesson 1: Getting Started

  • Topic A: Starting Out
  • Topic B: About Workbooks
  • Topic C: Exploring your Workbook
  • Topic D: Getting Help with Excel

Lesson 2: The Excel Interface

  • Topic A: The Quick Access Toolbar and File Menu
  • Topic B: The Home Tab
  • Topic C: The Insert Tab
  • Topic D: The Page Layout Tab
  • Topic E: The Formulas Tab
  • Topic F: The Data Tab
  • Topic G: The Review Tab

Lesson 3: Excel Basics

  • Topic A: Working with Excel
  • Topic B: Basic Excel Features
  • Topic C: Moving your Data
  • Topic D: Custom Actions and Options Buttons
  • Topic E: Editing Tools

Lesson 4: Editing your Workbook

  • Topic A: Modifying Cells and Data
  • Topic B: Cell Formatting
  • Topic C: Enhancing a Worksheet’s Appearance
  • Topic D: Working with Charts, Part 1
  • Topic E: Working with Charts, Part 2

Lesson 5: Printing and Viewing your Workbook

  • Topic A: Using the View Tab
  • Topic B: Managing a Single Window
  • Topic C: Managing Multiple Windows
  • Topic D: Printing your Workbook

Intermediate

Lesson 1: Advanced File Tasks

  • Topic A: Using Windows Explorer within Excel
  • Topic B: Saving your Files
  • Topic C: Using File Management Tools, Part One
  • Topic D: Using File Management Tools, Part Two

Lesson 2: Working with Functions and Formulas

  • Topic A: Using Formulas in Excel, Part 1
  • Topic B: Using Formulas in Excel, Part 2
  • Topic C: Exploring Excel Functions
  • Topic D: Using Functions in Excel
  • Topic E: Working with Names and Ranges
  • Topic F: Working with Array Formulas

Lesson 3: Managing Tables

  • Topic A: Working with Tables
  • Topic B: Working with Records and Fields
  • Topic C: Working with Tables and Filters
  • Topic D: Using Excel as a Database

Lesson 4: Adding the Finishing Touches

  • Topic A: Research Tools
  • Topic B: Using Themes
  • Topic C: Adding Text Boxes
  • Topic D: Inserting Pictures and ClipArt
  • Topic E: Editing Pictures

Lesson 5: Showing Data as a Graphic

  • Topic A: Inserting SmartArt
  • Topic B: Formatting SmartArt
  • Topic C: Adding Symbols, Equations, and Shapes
  • Topic D: Adding Sparklines
  • Topic E: Editing Sparklines

Advanced

Lesson 1: Getting the Most from Your Data

  • Topic A: Outlining and Grouping Data
  • Topic B: Exploring Scenarios
  • Topic C: Using Data Analysis Tools
  • Topic D: Using Solver
  • Topic E: Excel and Hyperlinks

Lesson 2: Pivoting Data

  • Topic A: Getting Started with PivotTables
  • Topic B: Working with PivotTable Data
  • Topic C: Formatting a PivotTable
  • Topic D: Using the Classic PivotTable Layout
  • Topic E: Advanced PivotTable Tasks

Lesson 3: Charting Pivoted Data

  • Topic A: Getting Started with PivotCharts
  • Topic B: Using the PivotChart Tools Tabs
  • Topic C: Formatting a PivotChart
  • Topic D: Advanced PivotChart Tasks

Lesson 4: Advanced Excel Tasks

  • Topic A: Using Advanced Functions
  • Topic B: Using the VLOOKUP Function
  • Topic C: Using Custom AutoFill Lists
  • Topic D: Linking, Consolidating, and Combining Data

Lesson 5: Macros, Visual Basic, and Excel Programming

  • Topic A: Creating a Basic Macro
  • Topic B: Visual Basic and Macros
  • Topic C: More Macro Tasks
  • Topic D: Advanced Visual Basic Tasks