Excel - PivotTables and PivotCharts

Level - Advanced

Transform raw data into clear insights.

Designed for people who work with large data sets, this course helps you turn complex information into clear, meaningful summaries.

You’ll learn how to build PivotTables and PivotCharts that highlight trends, support analysis and communicate results with impact.

Location

Date

Duration

1 Day

Time (AWST)

Address

Participants

Total

What to expect

PivotTables are one of Excel’s most efficient tools for transforming raw data into structured, meaningful information. This course shows you how to prepare your data properly and create PivotTables that help you summarise, filter and explore results quickly.

You will learn how to sort data, drill down into details, group information and customise layouts to suit different reporting needs. Guided practice builds your understanding of how to reshape and refine data for deeper insights.

The course also introduces PivotCharts, giving you the skills to present findings visually and highlight key patterns at a glance. By the end, you’ll be able to create flexible, professional summaries and visuals that support clear decision making.

Is this course for you

This course is ideal for anyone working with large data sets who wants to quickly analyse and present key information in a way that decision makers can use.

This course is suited to individuals who want to:

analyse large data sets efficiently
identify and summarise key insights
present information clearly for decision-makers
support informed and timely decisions through data

What you will explore

During this training course, you will develop practical skills to analyse and present data using Excel PivotTables and PivotCharts. The course focuses on preparing data correctly, using advanced analysis features, and customising layouts to communicate insights clearly and effectively.

By the end of this training course, you should be able to:

Prepare your data and set up PivotTables correctly
Summarise, filter and sort data for deeper analysis
Create PivotCharts to present findings visually
Use advanced options to drill down and group data
Customise layouts and formatting for clear communication

Where this course can take you

During this training course, you will explore how to prepare data for PivotTables and create and set them up effectively. You will learn how to summarise, filter, and sort large data sets, and use advanced PivotTable options for grouping and drill-down analysis.

The course also focuses on building PivotCharts to visualise key findings and customising layouts, styles, and formatting to support clear and effective communication of insights.