PivotTable Basics
  • Downloadable Workbook - download the workbook to work along with the lessons
  • Introduction to PivotTables
  • Create a basic PivotTable
  • Format a PivotTable
  • Value Field Settings
  • Update/Refresh Data
Advanced PivotTable techniques
  • Downloadable workbook
  • Configuring subtotals and grand totals
  • Multiple data points
  • Adding slicers and timelines to your PivotTable
  • Adding conditional formatting to your PivotTable
  • Table Calculations