Advanced Pivot Table Techniques in Microsoft Excel

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.

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

Related Courses

Microsoft Excel: Advanced Formulas and Functions

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

Advanced Pivot Table Techniques in Microsoft Excel

Course Duration:

1 Day (9.00am – 5.00pm)

Course Fee Details:

$305.20 (incl. of 9% GST)

SkillsFuture Credits & UTAP claimable

SDF grant entitled, $2/hr x 7hrs = $14
Eligible for Singaporeans, and PR employees

Course Code: TGS-2020503212

Course Schedule

Course NameCourse CodeVenueMarch 2024April 2024May 2024June 2024July 2024August 2024September 2024
Advanced Pivot Table Techniques in Microsoft ExcelTGS-2020503212JTC Summit-02-12-12-
TGS-2020503212Mountbatten Square22-13-11-12

Nett Course Fee
$305.20