Flexible Training Options

Choose a single focused 90-minute session, combine several sessions into a short course, or ask us about ongoing training support for your team.

Focused 90-minute sessions for specific skills
Grouped sessions to build a complete learning path
Ongoing support options for teams who need regular help

Tell us what you need

Tell Me More

Testimonials

FMG Consulting

"Very engaging & helpful, Simon my course teacher was great!"

Bedfordshire OPCC

"Simon was a fantastic training facilitator and made the session fun and easy to engage with. When one of my colleagues was concerned about how the skills learnt would transfer to her role, Simon took the time to design an activity (on the spot) that would apply to her and her role. Thank you for the brilliant session Simon - we can't wait to put our new skills to the test!"

BUUK Infrastructure

" I found the training excellent, I thought Simon's knowledge was great and he helped with some slightly off topic excel queries - I learnt so much from this workshop! I have undertaken this course before and the learning did not stick, but Simon's story telling and contextulisation has made it much more memorable."

GKN Aerospace

"Great, Gary was amazing and taught me loads "

This Course in Other Locations

This course is available online instructor-led, at client premises, and at selected training locations across the UK.

View all available locations for this course

Learn Excel Pivot Tables in 90 Minutes Part 1

Learn Excel Pivot Tables in 90 Minutes Part 1 Overview

This course introduces the power of PivotTables in Microsoft Excel and shows how they can quickly turn raw data into meaningful insights. Participants will learn how to create PivotTables, analyse trends, group information, and customise reports so that large data sets become easier to understand and present.

By the end of the session, you will feel confident exploring data, summarising results, and presenting clear analytical views using PivotTables and PivotCharts.

Compare Pivot Table Training Options

	90-Minute Pivot Table Course (Essentials)	Full-Day Pivot Table Course (Advanced & Comprehensive)
Best for	Beginners or users who need a quick, practical overview of PivotTables.	Users who want to master PivotTables and work confidently with more complex datasets.
Main focus	Focuses purely on core PivotTable skills.	Includes PivotTables plus a wider range of advanced Excel analysis techniques.
Coverage	Step-by-step introduction from data preparation to building, analysing and visualising PivotTables.	Covers everything from the basics through to advanced reporting, modelling and analytical techniques.
Tools covered	Sorting, grouping, filtering, slicers and PivotCharts.	PivotTables, formulas such as IF, SUMIF, VLOOKUP and INDEX MATCH, plus Excel Tables, PowerPivot and DAX.
Advanced features	Keeps the focus on practical everyday reporting and essential PivotTable use cases.	Teaches data modelling, relationships, advanced calculations and deeper analytics.
Ideal choice if...	You want a concise session that gets you using PivotTables quickly and confidently.	You want comprehensive training that goes beyond PivotTables into advanced Excel analysis.

Need a more comprehensive Pivot Table course instead? View the Full-Day Pivot Table Course

Course Duration: 90 Minutes

Course Prerequisites

Participants should have:

A basic knowledge of Microsoft Excel
Experience entering data and working with worksheets

Knowledge of PivotTables is not required.

Complete Course Outline

Introduction to PivotTables

Understanding what a PivotTable is and why it is useful
What type of data works best with PivotTables
Preparing data so it can be analysed effectively
Exploring the PivotTable interface

Creating Your First PivotTable

Creating a PivotTable step-by-step
Placing PivotTables on a new worksheet
Understanding rows, columns, values and filters
Formatting and adjusting PivotTable values

Analysing Sales Data

Building a PivotTable to analyse sales by salesperson
Summarising results using totals and averages
Renaming and formatting PivotTable headings
Applying built-in PivotTable styles

Sorting and Grouping Data

Sorting PivotTable data by totals
Sorting information within groups
Grouping dates into years, quarters and months
Understanding how sorting works in PivotTables

Updating and Managing PivotTables

Refreshing PivotTables when data changes
Expanding the source data dynamically
Changing the layout and structure of PivotTables

Working with Subtotals and Layout

Using subtotals to summarise grouped data
Creating clearer report layouts
Building cross-reference PivotTables

Visualising Data

Creating PivotCharts from PivotTables
Using slicers to filter reports visually
Building interactive PivotTable reports

This course is designed for Excel users who work with lists of data and want to summarise and analyse that information more effectively.

During the session, you will learn how PivotTables organise and summarise data, how to build them step-by-step, and how to customise them to answer real business questions. The course also introduces sorting, grouping, calculated views, and visual tools such as PivotCharts and slicers.

Practical examples and exercises will help you understand how PivotTables can simplify reporting and reveal patterns that would otherwise be difficult to spot.

Training Locations and Delivery Options

This course is available online instructor-led, at client premises, and at selected training venues across the UK.

View training centres and venue information