Excel Pivot Tables
Upcoming dates
Click a date to book online.
| Location | Sept 26 | Oct 26 | Dec 26 |
|---|---|---|---|
| Auckland | |||
| Hamilton | |||
| Wellington | |||
| Christchurch | |||
| Virtual |
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 Wed, 9 Sept 2026, and there are 9 further dates scheduled. Delivered live online, ACE Training Wellington, ACE Training Christchurch, ACE Training Auckland. 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.
Can we pay by invoice instead of by card?
Yes. Choose 'Pay by invoice' when you book and we'll hold your place and send the invoice to your accounts address, with a purchase order number on it if you need one. You can also pay by card at the time of booking if that's easier.
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.