The "Show Value As" Functionality of a Pivot Table
Format a PivotTable
External Data
PowerPivot
PowerPivot Functions
Filter Data Using Slicers
Slicers
The Insert Slicers Dialog Box
Analyse Data with PivotCharts
PivotCharts
Create PivotCharts
Applying a Style to a PivotChart
Things to remember
Please arrive 5-10 minutes before the scheduled start time so you can get yourself a cup of tea and get settled in the training room.
There will be a 15 minute tea break half way through the course.
FAQ's
What Experience do I need to attend this course?
You should have attended our Excel Level 1 course, at at minimum already be comfortable with the basics of Excel, including basic formulas and functions, and basic charts.