Excel 365 Pivot Tables
Learn to create PivotTables, use slicers for data filtering, and analyze data with PivotCharts, including styling and PowerPivot functions.
Crimp Business Park
In-person
3hrs
£50
What happens at this event?
Create a PivotTable
- PivotTables
- Start with Questions, end with Structure
- The Create PivotTable Dialog Box
- The PivotTable Fields Task Pane
- Summarise Data in a PivotTable
- 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
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.
Event Location
Gallery (1)