Sales Ended

Microsoft Excel - Pivot Tables

Event Information

Share this event

Date and Time

Location

Location

Karstens Training Centre

123 Queen Street

Melbourne, VIC 3000

Australia

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

You have data, but what you really need is information. This is where Pivot Tables come in. One of the most powerful features of Excel, Pivot Tables take you far beyond basic filtering to analyse your data and help you to make better business decisions.

This ½ Day training course will quickly have you up and running with the key features of Pivot Tables. You will learn tips and tricks to speed up your work and get the most out of this most versatile of features.

This is an Intermediate level course.

What you get

  • Class size kept to a maximum of 10 participants.
  • Average class is 4-6 people.
  • Qualified, experienced and approachable facilitators.
  • Training materials and take away practice files.
  • Lifetime post course support.

We encourage you to bring along your own laptop so you are familiar with its layout and functionality. If you do not have a laptop, we can supply one on the training day.

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

Date and Time

Location

Karstens Training Centre

123 Queen Street

Melbourne, VIC 3000

Australia

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved