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)

Excel 2010
Powerpoint 2010

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)

Book In!
back to top

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!

arrow

privacy We value your privacy and would never spam you