(03) 9999 7780

Call for Queries?

Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel PivotTables

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.

What you need to Bring

  • Laptop with the relevant software installed.

People feel more comfortable using their own laptop, since they will be familiar with its layout and options. Having access to all of your applications and customisations will come in handy through the training.

  • No laptop? Please get in contact with us.

If you don’t have a laptop, please let us know beforehand so we can supply one on the training day.

Am I Ready For This Training?

Participants should have a thorough understanding of the fundamentals of Microsoft Excel. Ideally you will have completed our Microsoft Excel Intermediate training course, or have solid experience using Excel Spreadsheets, including creating formulas, using functions, and working with data, including sorting and filtering.

Once you’ve completed this course, you can extend your knowledge further by attending one of our Managing Data courses.

Course Details

Course Skill Level

Intermediate

Class Size

Public Courses 6 Students (Max)
Client Site Courses 10 Students

Course Duration

½ Day Training Course

Class Times

9:00am – 12:30pm or 1:00pm – 4:30pm

Your Course Includes

Price

$265+GST

Upcoming Public Courses

Courses
Online Training Delivery
Wed, 8th Sep 2021
Online Training Delivery
Wed, 8th Sep 2021
Online Training Delivery
Wed, 9th Mar 2022
Online Training Delivery
Wed, 9th Mar 2022

Course Delivery Style

Face to Face Training Delivery

Face 2 Face 

Online Training Delivery

Online

Still Need Approval?

Want to reserve a seat but you still need approval?

No problem, simply call us on (03) 9999 7780 and we will hold a seat for you.  There’s zero risk, if you don’t get approval, we’ll cancel the reservation.

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.

Keystroke Learning - Building Computer Skills to Enable Success

Learn Today Face to Face Online 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
Interested in learning more about our offerings?
Our team will take the time to discuss your requirements and help you make smart decisions that best meet your needs.
© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759
Keystroke Learning - Building Computer Skills to Enable Success

Log in

Keystroke Learning - Building Computer Skills to Enable Success

Melbourne Training Centre

Suite 613, Level 6,   1 Queens Road Melbourne, VIC 3004

Venue Access Hours

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

Are you Running Late???