Download our guide to end user applications

Microsoft Excel - Tables and Pivot Tables [NXC]

Length 1 day

Course overview

View dates &
book now

Why study this course

Enhance your Excel proficiency with our Excel Tables and Pivot Tables course. This one-day workshop is meticulously designed for corporate professionals aiming to harness the full potential of Excel’s Pivot Tables and key analysis tools for data modelling and manipulation. Learn to create and filter PivotTable reports and charts, handle large data sets efficiently, summarise complex data, and ensure data accuracy through validation. This course equips you with the critical skills needed to excel in today's data-driven corporate environment.

Note: Excel 2016, Excel 2019, Excel 2021, and Excel 365 are all desktop application versions of Microsoft Excel. Excel 2016, Excel 2019, and Excel 2021 are the perpetual, bought-outright, stand-alone versions of the software; Excel 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Book now!

Request Course Information

What you’ll learn

At the completion of this course you should be able to:

Create and filter PivotTable reports to analyse data
Create and manipulate PivotTable charts for graphical data representation
Use sort and filter features to efficiently analyse large data sets
Work with Excel tables to summarise and manage data
Consolidate data into comprehensive reports using Data Consolidation
Use Data Validation to control and ensure accurate data input

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This course is ideal for professionals who need to analyse large data sets, create detailed reports, and improve their Excel efficiency.

Course subjects

Introduction to PivotTables

Creating and modifying PivotTable reports
Analysing data using PivotTables
Grouping field items for better data organisation
Building a PivotTable based on an Excel Table
Displaying and understanding source data in PivotTables
Filtering and sorting labels and data
Using Slicers and Timelines for advanced filtering

Sort and Filter Table Data

Sorting data using AutoFilter buttons or the Sort dialog box
Creating and applying Custom filters for specific data views
Subtotalling filtered lists for better data understanding

Working with Excel Tables

Understanding formatting and management with Excel Tables
Filtering data with Slicers for quick insights
Deleting duplicates using Conditional Formatting for data accuracy

Smart Charting Techniques

Creating and modifying PivotCharts for data visualisation
Adding a secondary axis and trendlines for enhanced analysis

Outlining Data

Using the Outline feature to summarise large worksheets
Displaying only the necessary totals for clear data presentation

Data Validation

Controlling data entry using Data Validation rules
Setting up various data validation settings for consistent data entry
Creating input and error messages to guide users
Circling and clearing invalid data entries in Excel
Locking cells with data validation to protect data integrity

Prerequisites

Prior to undertaking this course, students should have successfully completed the Intermediate course or have equivalent experience. Familiarity with Named Ranges is an advantage.

M365 Adoption and Training Plans

Our aim is to help educate and enable your organisation to get the best return on your Microsoft 365 investment.

Learn more

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.