Pivot Table Essentials

This session will cover the basics of pivot table creation as well as solving some common frustrations. Topics covered include
  • pivot cache what it is and why it is important
  • data rules that make creating pivot tables easier
  • format as table and why you need to use it
  • populating missing entries in the data – manually and with Power Query
  • the basics of creation
  • pivot charts
  • filtering with slicers
  • grouping
As always, I will share a few general tips along the way.
5 Lessons