Mountains
In person

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
£50
3hrs
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
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.
Event Location
Gallery (1)