Course Introduction
  • What's a QuickStart Course?
First Case Study: Just the Basics!
  • Getting Started with Entering Data and Formulas
  • Filtering and Sorting Data; Adding Totals
  • Working with Excel Data
Sales Reporting Case Study - Including Pivot Tables, Charts, IF and VLOOKUP
  • Sales Reporting and Analysis: An Introduction
  • Preparing Data for Analysis: Advanced Functions: IF, VLOOKUP and table functions
  • Pivot Tables to Summarize Data
  • Displaying the Results with Beautiful Charts
  • Working with Pivot Tables
  • Wrap Up and Next Steps