Course Intro and Format | Important! :)
  • Course Format and Structure
Pivot Tables | The Fundamentals
  • PLEASE DOWNLOAD THE PRACTICE FILE
  • First... Let's get familiar with our data
  • So... What exactly are excel pivot tables?
  • Building our first pivot table
  • Ooops!! My field list!!!
  • Ok...Let's build another pivot table :)
  • Pivot table design considerations
  • Multi-field pivot tables
  • Sorting pivot tables
  • Filtering pivot tables
  • Adding date fields to pivot tables
  • Basic formatting
  • Refreshing data
  • Report totals and layouts
  • Enjoying the course?
Working with calculations in pivot tables
  • It all starts with the SUM...
  • Average, MIN and MAX
  • Multifield calculations
  • Calculated Fields
  • List formulas
  • Calculated Items
  • % of grand total
  • % of column total
  • % of parent total
  • Rank Function
  • Running totals
Intro to slicers
  • Meet the slicer
  • Using multiple slicers
  • Timeline filters
  • Slicer options
  • Connecting multiple slicers
Pivot Table Charts
  • Creating basic pivot table charts
  • Formatting charts
Miscellaneous, yet relevant topics :)
  • Clearing Pivot Table Fields
  • Missing field list?
  • Error handling
  • Drill down into data
  • GETPIVOTDATA Function
The 4 Minute Dashboard
  • The 4 Minute Dashboard
Homework?? And thank you so very much!
  • Homework and class wrap-up
  • SUPPLEMENTAL MATERIAL