Advanced Microsoft Excel Training - Pivot Tables
Pick and choose the modules that you want your staff to learn, and we'll do the training in-house! (Sydney Metro only)
Pivot Tables - Microsoft Excel 2010 → Office 365
PivotTables is one of the most powerful reporting features that Excel has to offer, and yet is also one of the least understood and most underutilised functions available. In this 3.5 hour crash course on PivotTables you will learn not only how to create pivot tables, but how to manipulate the data, summarise the data, and present the data in the exact format that works best for your reporting needs.
Once you’ve finished this course you will be the office Guru on PivotTables.
Topics Covered - 3.5 Hours
- 1. Introduction to PivotTables
- 2. Creating & Pivoting PivotTables
- 3. Summarising PivotTable Data
- 4. Sorting & Filtering PivotTable Data
- 5. Formatting PivotTables
- 6. Applying Conditional Formatting to PivotTables
- 7. Creating & Manipulating PivotCharts
8 Participant Maximum - $1097 + GST
($137 per person for a group of 8)


It’s great… one of our staff members came out and said that it was the best training that they’d ever done! That’s exactly what we want to hear!
Paul Johnson - Workforce Planning Manager, Covermore Travel Insurance
John is definitely one of the most remarkable trainers I have met during my 22 years of studies. He is a very knowledgeable, inspiring, motivating and creative hands-on teacher which makes it a great experience to attend his classes.
Diana Bakos, Kaplan International
Learn The 10 Excel Shortcuts That Helped Me Keep My Job!
We value your privacy and would never spam you