(03) 9999 7780

Call For Queries?

Training Centre

View on Map

Keystroke Learning - Main Menu

(03) 9999 7780

Call For Queries?

Keystroke Learning - Main Menu
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 

Microsoft Excel PivotTables

Microsoft Excel Computer Training Course

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.

Course Details

Course Skill Level


Class Size

10 Students (max)

Course Duration

½ Day Training Course

Class Times

9:00am -12:30pm



Upcoming Public Courses

online training deliveryCourse delivery via our Live Online Training
Thu, 18 Feb 2021
Face to Face training deliveryCourse delivery as Face to Face training
Thu, 15 Apr 2021
There are no upcoming courses at this time.
However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.

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
  • Preparing the PivotTable
  • Creating a PivotChart
  • Modifying PivotCharts
Consolidating PivotTables
  • Consolidating Worksheets
  • Assigning Multiple Data Ranges to a Field Name
  • Analysing the Consolidated Information
Keystroke Learning - Building Computer Skills to Enable Success

Face to Face
 with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses

call (03) 9999 7780 or email us @ info@keystrokelearning.com.au

Melbourne Training Venue

Level 2 / 52 Albert Rd
South Melbourne, VIC, 3205

Venue Access Hours

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

Are you Running Late???

Keystroke Learning - Building Computer Skills to Enable Success

Log in