Attendance / Duration
2 Evenings (6:00pm - 8:30pm)Overview
This 2 evening session course is designed to provide participants with a solid foundation in creating and utilising pivot tables in Microsoft Excel. They will learn how to summarise, analyse, and present large datasets effectively, making data-driven decisions with ease.Cost
£185. Full funding is available through the Training Access Fund (TAF) subject to individual eligibility. Click 'Apply Now' to check your eligibility and complete your application.
Course Dates
- Wednesday, 16 December 2026 (18:30 - 21:00)
- Thursday, 17 December 2026 (18:30 - 21:00)
What's Involved?
A PivotTable is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons, patterns, and trends in your data.
This course is designed to provide participants with a solid foundation in creating and utilising pivot tables in Microsoft Excel. They will learn how to summarise, analyse, and present large datasets effectively, making data-driven decisions with ease.
Participants should have a basic understanding of Microsoft Excel, including working with worksheets, using functions and formulas, and basic data manipulation. It is not suitable for those at a beginner Excel level.
The course is suitable for those using Microsoft Office 2013 or above
Course Content
- This course will cover the following:
- Preparing data for use in pivot tables
- Creating a pivot table
- Designing a pivot table
- Formatting and sorting data
- Grouping data
- Filtering a pivot table
- Creating charts from pivot tables
- Creating a multi-level pivot table to view multiple metrics
- Changing measurement units to display data in different ways
- Updating a pivot table
- Using calculations in a pivot table
By the end of this course participants will learn how to summarise, group and display large amounts of data to communicate relevant information.