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.
Booking Options
Age Requirement
This event is suitable for all ages
All attendees under the age of 16 must be accompanied by a parent/guardian.