INTRODUCTION & DATA PREPARATION
Pivot Intro
Pivot Cache
Altering the Data Source
Unpivot data to a long boring list
Moving row and column
Expand and Collapse field
LAYOUT AND FORMATS
Format Error and Empty cells
Change Layout of Pivot Table
Place Pivot Table
Pivot Table Styles
Format Content in Pivot
CORE PIVOT TABLE ANALYSIS
Summarise Value by
Multiple Subtotal
Percentage of column total
Difference From value as percentage
Double click for detail
Running Total
Grouping Year Month Quarter
Sorting
FILTERS AND SLICERS
Filtering – Part 1
Filtering – Part 2
Slicer – Insert Style Property
One Slicer connected to Multiple Pivots
Timeline Slicer
ADVANCED ANALYSIS
Calculated Field
Link Multiple Table into One Pivot – Part 1
Link Multiple Table into One Pivot – Part 2
Calculated Field with IF statement
VISUALS AND REPORTS
Conditional Formatting in Pivot – Part 1
Conditional Formatting in Pivot – Part 2
PivotCharts Part 1
PivotCharts Part 2 – Linking and Slicers
PivotCharts Part 3 – Formatting
Dashboard 1 – What we will build
Dashboard 2 – Our Dataset
Dashboard 3 – Pie Chart
Dashboard 4 – Line Chart
Dashboard 5 – Bar Chart
Dashboard 6 – Map Chart
Dashboard 7 – Putting it all together
Outro