Course curriculum

  • 01
    Getting Started
    Show Content
    • Course Overview
    • Learning Outcomes
    • Exercises
    • Pivot Table Data Sets
    • Introduction
  • 02
    Getting Started with Microsoft Excel
    Show Content
    • Getting Started with Microsoft Excel
    • EXERCISE #1: Getting Familiar With Excel Core Functionality
    • Review What You've Learned
  • 03
    Worksheets and Workbooks
    Show Content
    • Overview
    • EXERCISE #2: Worksheets and Workbooks
    • Review What You've Learned
  • 04
    Entering and Organizing Data
    Show Content
    • Overview
    • EXERCISE #3: Entering and Organizing Data
    • Review What You've Learned
  • 05
    Formatting and Organizing Data
    Show Content
    • Overview
    • EXERCISE #4: Formatting and Organizing Data
    • Review What You've Learned
  • 06
    Formulas and Functions
    Show Content
    • Overview
    • Absolute and Relative Cell References
    • Typical Formulas and Functions
    • Manipulating Text, Statistics, Lookup Functions and Formula Errors
    • EXERCISE #5: Formulas and Functions
    • EXERCISE #6: Advanced Formulas and Functions
    • Review What You've Learned
  • 07
    Charts and Graphs
    Show Content
    • Overview
    • EXERCISE #7: Charts and Graphs
    • Review What You've Learned
  • 08
    Pivot Tables
    Show Content
    • Overview
    • Pivot Table Basics
    • Advanced Usage and Concepts
    • Slicers and Options
    • EXERCISE #8: Pivot Tables
    • Review What You've Learned
  • 09
    Printing and Saving
    Show Content
    • Overview
    • EXERCISE #9: Printing and Saving
    • Review What You've Learned
  • 10
    Wrap Up
    Show Content
    • Wrap Up
    • Reflect On Your Learning
    • Share Your Feedback