book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Excel – Data Handling and Analysis with PivotTables & PivotCharts

Microsoft Excel new logo with Microsoft Partner written on it.
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Excel – Data Handling and Analysis with PivotTables & PivotCharts

$325per person

In Person Virtual

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 1:00 pm to 4:00 pm
Duration: Half Day

Join in-person at our vibrant Perth CBD training centre. Refreshments are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

Take your Excel skills to the next level with this half-day course

Designed for experienced Excel users, this practical session explores powerful data analysis techniques and shows you how to combine multiple PivotTables and PivotCharts to turn complex data into clear, actionable insights.

Dates

Book a course

Course Information

Course Content

Preparing Data

  • Understanding your source data & its limitations
  • Importing/exporting data
  • Removing duplicates
  • Splitting columns

Store Data

  • Understanding Excel lists and Excel tables
  • Creating an Excel table
  • Working with Excel tables

Analyse Data

  • Understanding PivotTables
  • Creating a PivotTable
  • Manipulating PivotTable fields
  • Working with data calculations
  • Counting in a PivotTable
  • Displaying values as the percentage of total
  • Grouping in PivotTable reports
  • Creating calculated fields and items
  • Sorting in a PivotTable
  • Updating data
  • Adding and changing records in the PivotTable data source

Display Data

  • Formatting Pivot Table values
  • Assigning custom names
  • Working with slicers
  • Working with the timeline
  • Creating PivotCharts
  • Working with PivotChart elements

Advanced Pivot Tables

  • Combing multiple PivotTables

Get in touch

Excel in business with our premier Microsoft Excel training and more. Whether you’re looking to upskill through training or need tailored support through our consultancy services, we’re here to help.

To learn more about our Microsoft Excel course or how we can support your data goals, please contact us today or give us a call on (08) 9218 9059.

On completion of this course participants will be able to identify and prepare Excel data for analysis, create and manipulate PivotTables and PivotCharts.

Completion of Excel Intermediate course or equivalent knowledge is required.

FAQs

Which Excel courses would you recommend I complete next?
Are your courses available online or in person?