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 New Flexible Workforce Development Fund (NFWDF) subject to individual eligibility. Please note, the NFWDF requires you to discuss your application with your employer before applying. If you have already done this, or if you/your employer is paying your fee, please click 'Apply Now'.
If you would prefer not to inform your employer, please apply using this link instead.
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.