Building Computer Skills to Enable Success
Building Computer Skills to Enable Success
Microsoft Excel PivotTables
What Your Team Will Learn
Ready for your team to master the most powerful data analysis tool in Excel? Welcome to our “Microsoft Excel PivotTables” course, where we’ll transform your staff from data browsers into dynamic reporting experts!
Ever seen colleagues spend hours manually summarising data, knowing there must be a faster way?
Or watched your team struggle with massive datasets, wishing they could instantly spot trends and patterns? Get ready for your staff to unleash the power of PivotTables and revolutionise the way they analyse data!
In this half-day of learning, we’ll take your group from PivotTable novices to confident data analysts. Whether they’re new to PivotTables or have dabbled with them before, this focused course will show them how to turn raw data into meaningful insights in minutes. Think of it as giving your staff a data-analysis superpower, they’ll discover how to consolidate multiple data sources into a single, powerful analysis that impresses colleagues and saves countless hours of work!
What You'll Get With This Course
Live Instructor-Led Training
Highly experienced and approachable trainers
Comprehensive Materials
eCertificate of Completion
Proudly recognise your achievement
Lifetime Support
Expert help, always within reach
Skill Level: Intermediate
Duration: ½ Day
Time: 9:00am – 12:00pm
CPD Hours: 3hrs
Microsoft Excel PivotTables Course Content
Data Preparation
- Preparing Data
- Working with List Data
- Working with Tables
Working with Text
- Cleaning up Text
- Converting Text to Columns
- Removing Duplicates
- Flash Fill
- Text Functions
Creating PivotTables
- Building a PivotTable Shell
- Adding Fields
- Grouping Items
- Filtering
- Drilling Down
- Changing Layouts
Advanced PivotTable Features
- Using Slicers
- Using PivotTable Options
- Creating Calculated Fields
- GetPivotData Function
- Show Report Filter Pages
PivotCharts
- Preparing the PivotTable
- Creating a PivotChart
- Modifying PivotCharts
Consolidating PivotTables
- Consolidating Worksheets
- Assigning Multiple Data Ranges to a Field Name
- Analysing the Consolidated Information
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.
Want to run this course for your staff?
Standard course ready to go — customisation available if your team needs it.
Our Clients
FAQ's
We know team training comes with a lot of questions, who, what, how many, when, where, and sometimes even why. To save you a few clicks (and a few minutes), we’ve pulled together the most common ones we get from other HR managers, L&D teams, and people just like you.
Where can this Microsoft Excel PivotTables training be delivered?
We can run PivotTables training directly in your workplace, live online, or in a hybrid format. In-person sessions are great for teams who like working side by side, while online delivery allows staff in different locations to join seamlessly. Hybrid delivery means you don’t have to choose — some can attend in person while others log in remotely.
How many staff can attend a Microsoft Excel PivotTables training session?
We recommend small to medium-sized groups, as this gives participants time to experiment with PivotTables and get personalised support. We’ll suggest an ideal number, but we can adapt to the size of your team. The main goal is to keep the session interactive and hands-on.
Can we schedule the Microsoft Excel PivotTables training at a time that suits us?
Yes, we’ll arrange training at times that work best for your organisation. Whether you’d like a short half-day workshop or a full day to go deeper into PivotTables, we’ll make it fit around your team’s schedule. Shorter, spread-out sessions are also possible if that’s easier for your staff.
What will my team be able to do after the Microsoft Excel PivotTables course?
After this course, staff will know how to create PivotTables from raw data, customise them to show meaningful information, and apply filters and grouping to drill into details. They’ll also learn how to summarise large amounts of data quickly and clearly. By the end, they’ll be able to generate reports that help your organisation make better business decisions.
Do participants need any prior knowledge of Microsoft Excel PivotTables?
Yes. Learners should already be confident with Excel basics, such as entering data, using formulas, and formatting worksheets. This ensures they can focus on learning PivotTable features without getting stuck on fundamentals.
Can the Microsoft Excel PivotTables training content be customised to our needs?
Absolutely. We can use your actual data or reporting requirements in the exercises, so staff can immediately see how PivotTables apply to their work. This makes the learning far more relevant and valuable to your team.
Will staff receive a certificate of completion?
Yes, all participants receive a certificate once they’ve completed the course. This can be shared internally or externally as proof of their professional development.
Do you provide support after the Microsoft Excel PivotTables training?
Yes, we offer lifetime support. If participants get stuck creating PivotTables later, they can reach out for help, ensuring they can continue applying what they’ve learned.
Get your team members to try our short, anonymous Microsoft Excel PivotTables skills test. You’ll discover your true proficiency level in minutes, no registration required
Prior Knowledge
This focused course is designed for users who have a good working knowledge of Microsoft Excel basics. You should be comfortable with creating worksheets and using basic formulas. Previous experience with PivotTables is not required, as we’ll cover both basic and advanced PivotTable techniques.
Required Software
You will need Microsoft Excel installed on your computer to participate in this course. This can be through a Microsoft 365 subscription or a perpetual license version.
Course Materials
All exercise files needed for the course will be provided. In some cases, you may receive them by email prior to the training so you can download them in advance. Otherwise, everything will be supplied during the session, and no preparation is required.
Note About Different Versions
While this course uses the latest version of Microsoft Excel, the PivotTable skills learned are transferable to recent versions. However, for the best learning experience and access to all features covered in the course, we recommend using the latest version of Microsoft Excel.
Brendon Farrell
Co-Founder / Facilitator
From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.
As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.
Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.
Mark Finney
Co-Founder / Facilitator
With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.
Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.
When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.