Introduction, Case Study and the Working File
  • Introduction
  • Case Study Explained
  • Don't forget to download the work file!
The Pivot Table
  • Preparing your Data for a Pivot Table
  • Your First Pivot Table - Row Function
  • The Values Field
  • Refreshing Data and Changing the Data Source
  • Columns Function
  • Filters Function
  • Report Layout Views
  • SubTotals, Grand Totals and Extra Value Fields
  • Pivot Design Styles and Formatting
  • Repeat Item Labels and Blanks
  • Copy Paste Out of Pivot
  • Congratulations