Introduction
  • Introduction - Why Pivot ?
  • Raw Data for Practice
Pvot from Begineer to Pro
  • Lets Begin
  • Some more with Pivot
  • Most common mistakes - Part 1
  • Auto Refresh and Most Common Mistakes - Part 2
  • Number format - All at Once
  • Using FIlters and Column box
  • Removing grand totals
  • Extracting report details in to seperate table
  • Adding Percentage summary
  • Displaying null rows
  • Top 10 option and Sorting
  • More features part - 1
  • Playing with dates - Grouping and Ungrouping
  • More features - part - 2
Bonus
  • Using Slicer
Want to learn more?
  • What more on your way