Microsoft Excel Pivot Tables

Lesson 1Create a Pivot Table report and manage the report’s layout.Lesson 2Extract data using Label, Value and report filters.Lesson 3Insert and manage Slicers to filter data.Lesson 4Generate additional subtotals by grouping both dates and numbers.Lesson 5Output statistics using COUNT, MAX and AVERAGE functions.Lesson 6Control Pivot Table number formatting.Lesson 7Summarise numbers with percentage analyses.Lesson 8Create a Difference From analyses to compare different sets of data.Lesson 9Output tailored formula results using Calculated Fields.Lesson 10Insert a Pivot Chart to visually represent report data.Lesson 11Finish off with a user-friendly front-end dashboard control.