Advanced Pivot Tables

This session expands on the essential section.
Topics covered include
  • Calculated Fields – what they are and how and why to use them
  • Calculated Items – what they are and how and why to use them
  • Advanced filtering
  • Useful Report Layouts
  • Conditional Formatting
  • Adding relationships so you can report on two tables as once
  • Data normalisation and variance analysis example using Power Query
  • Two handy macros that can speed up pivot table creation
As always, I will share a few general tips along the way.
5 Lessons