This session introduces Pivot Tables as one of Excel’s most powerful tools for analysing and summarising data. It is designed for users who want to move beyond raw spreadsheets and start answering real questions with their data.

You will learn how to build Pivot Tables from clean data, understand how rows, columns, values, and filters work together, and explore tools such as sorting, grouping, slicers, and calculated fields.

By the end of the session, you’ll be able to use Pivot Tables confidently to identify trends, compare results, and explore datasets far more efficiently than with formulas alone.

This course is perfect for:

Microsoft 365 account. Completion of a beginner and intermediate Excel session is recommended.