Advanced Pivot Table Techniques in Microsoft Excel

Nett Course Fee
$305.20

Please be advised that as of 1st January 2025, there will be changes to both course fees and subsidies available.

Nett Course Fee (effective 1st January 2025)
$392.40

Course Description

Excel’s most powerful analytical tool is the PivotTable. In this course, you’ll be taught how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. You will also learn how to navigate the complexity of PivotTables to take advantage of their power. By the end of the course, you will be able to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable.

Prerequisites

To enrol in this course, you should possess the following:

(≥ 16 years old); or
1 year working experience

You must have attended Excel Advanced or has been using Excel for the past three years continuously with basic knowledge on setting up Pivot Tables. You must also know how to manage data sets task such as sorting & filtering.

Course Objectives

At the end of the 1-day course, you will learn to:

Prepare data source and create a PivotTable
Summarize multiple data fields, Manage subtotals and grand totals,
Create Grouping of PivotTable fields
Perform filter with selections, rules, search filters, slicers, and timeline
Apply PivotTable styles and format cells with conditional formatting
Show different calculations in PivotTable value fields
Create calculated fields using formulas and create calculated items with combine fields
Create PivotCharts

Course Outline

Introduction to PivotTable

Preparing data source to be use in PivotTable
Creating the PivotTable and Using external data source in PivotTable
Understand PivotTable Fields Pane and Structure
Building up the PivotTable and Pivoting it
Show report filter pages
Removing field from the PivotTable

Working with PivotChart

Printing PivotTables & PivotChart
Grouping problem and solution
Create Calculated field and Items in PivotTable
Converting a crosstab data into normal data list (optional)
Using multiple source data (optional)

Managing PivotTable

Grouping fields
Sorting and filtering PivotTable data
Refreshing PivotTable
Formatting the PivotTable
Summarizing PivotTable Data

The course “Microsoft Excel: Advanced Formulas and Functions” delves into advanced techniques such as Lookup functions for data retrieval, Statistical functions for criteria-based reports, Text functions for string extraction, and more, utilizing practical examples to facilitate seamless application of these formulas in real-world contexts.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Microsoft Excel: 99 Pro Hacks and Tips

Uncover the abundance of lesser-known productivity hacks within Microsoft Excel to enhance efficiency, avoid common pitfalls, and unlock the application’s full potential for a more effective work experience.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here