Introduction
  • Introduction on Pivot Table
PIVOT Tables from Basic To Pro
  • Lets Jump in
  • More on Pivot tables
  • Common Mistake - Mistake 1
  • Auto Refresh and Common Mistakes - Mistake 2
  • About Number Format - All At Once
  • Use of FIlters and Column box
  • Removing Grand Totals
  • Extract of report details in to separate table
  • Adding Percentage summary
  • Displaying null rows
  • Best Top 10 option and Sorting
  • Some More features part - 1
  • Playing with dates - Grouping and Ungrouping
  • More features - part - 2
Bonus Lesson
  • Use of Slicer