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 pp
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.
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.
Event Location
Gallery (1)