Customised computer training in Microsoft, Adobe and other Software

Microsoft Excel – Pivot Tables

Microsoft Excel - Pivot Tables training course available in Melbourne

Course Overview

Participants on this Microsoft Excel – Pivot Tables half day course will gain hands-on experience and insights into the fundamental aspects of Pivot Tables, including preparing your spreadsheet and working with various Pivot Table options, all without the need to be away from the office for a whole day.

The course assumes a working knowledge of Excel, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

On completion of this Pivot Tables course participants will learn to:

  • Prepare Data for Pivot Tables
  • Work with Text
  • Create a Pivot Table

  • Work with Advanced Features
  • Set up Pivot Charts
  • Use Multiple Ranges for Pivot Tables

Microsoft Excel – Pivot Tables Training Course Details

½ Day – Begins 9:00am or 1:00pm

Maximum of 10 students

One 15 min break


Brendon is excellent, he knows his stuff and is clearly passionate about teaching. He is approachable and answered all our questions. He highlighted the most appropriate areas and always mentioned real life examples


Microsoft Excel – Pivot Tables 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 Pivot Tables

  • Building a Pivot Table Shell
  • Adding Fields
  • Grouping Items
  • Filtering
  • Drilling Down
  • Changing Layouts
  • Using Slicers

Advanced Pivot Table Features

  • Using Pivot Table Options
  • Creating Calculated Fields
  • GetPivotData Function
  • Show Report Filter Pages

Pivot Charts

  • Preparing the Pivot Table
  • Creating a Pivot Chart
  • Modifying Pivot Charts

Consolidating Pivot Tables

  • Consolidating Worksheets
  • Assigning Multiple Data Ranges to a Field Name
  • Analysing the Consolidated Information

What’s Included in the Training Course?

To see what else is included for participants in our standard training courses please visit our Additional Course Information page.

Customise this Course

If you would like to customise this course, please Contact Us to discuss your requirements or fill in our Quote Form.

Request a
Call back


(03) 9999-7780
8 Arthur St, Caulfield North,
VIC, 3161


Monday – Friday:
8:00am – 5:30pm

Saturday – Sunday: