Advanced Pivot Table Techniques in Microsoft Excel

Course Overview

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.

Mode of Assessment

No Assessment

Course Duration

1 Day

Total Training Duration (Hour)

8 Hours

Course Outline

Introduction to PivotTable

- Preparing data source to be used 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

Certification Obtained and Conferred by

Upon successful completion of the Advanced Pivot Table Techniques in Microsoft Excel course, participants who have attended at least 75% of the course will receive a Certificate of Attendance by @ASK Training.

Course Learning Outcome

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 combined fields

- Create PivotCharts

Pre-requisites

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.

Price

	Course Fee Payable
Original Fee	Before GST	With GST (9%)
Course Fee	$360.00	$392.40
Corporate Pricing (Fee payable to Training Provider)
SME	Before GST	With GST (9%)
SDF Funding	$360.00	$392.40
Non-SME	Before GST	With GST (9%)
SDF Funding	$360.00	$392.40