Excel Pivot Tables
Overview
Learn how to group your data in a meaningful way. Excel Pivot Tables enable us to quickly group large sets of data with very little effort, almost as if by magic.In this specialized half-day course,you will transform a database with thousands of rows into an easy to read report. Quickly capture the average sales price per month or compare performance by region. For those of us who find numbers hard to visualize, we will see how to put that data into Pivot Charts so we can spot trends and changes in the data.
Who should attend
This course is designed for analysts, managers, or anyone who uses Excel to get insights from business data. If you work with big data sets on a regular basis and spend lots of time sorting through your data, doing complex calculations or SUMIF functions then this is the course for you.
Prerequisites
We recommend that students have knowledge equivalent to the topics covered in our Excel Essential Skills course, OR that students are:
- Comfortable creating Excel formulae
- Familiar with basic Excel functions (SUM, COUNT, AVERAGE)
- Familiar with absolute references ($A$1)
If you are new to Excel, we suggest starting with Excel Essentials Skills before tackling this course.
What you'll learn
Take the mystery out of Pivot Tables and let Excel do all the hard work of tricky calculations for you. You’ll leave this course ready to tackle your data and pivot it into insights.
Course content
- The Excel Window
- PivotTables Summarising Data
- PivotTables Sorting and Filtering
- PivotTables Formatting
- PivotTables Extras
- Creating Pivot Charts
Common questions
When does Excel Pivot Tables next run?
The next date is Thu, 3 Sept 2026, and there are 10 further dates scheduled. Delivered ACE Training Hamilton, live online, ACE Training Wellington, ACE Training Christchurch. Every date and its format is listed on this page.
How much does Excel Pivot Tables cost?
From $345 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
We recommend that students have knowledge equivalent to the topics covered in our Excel Essential Skills course, OR that students are: Comfortable creating Excel formulae Familiar with basic Excel functions (SUM, COUNT, AVERAGE) Familiar with absolute references ($A$1) If you are new to Excel, we suggest starting with…
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code Excel-Pivot-Tables when you enquire.