Skip To Content
Data Analysis using Excel PivotTable is a Program

Data Analysis using Excel PivotTable

Time limit: 7 days

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Data Analysis using Excel PivotTable

Course Overview

NTUC LearningHub Course Code: MSEDAPT

SSG SkillsConnect Reference Number: CRS-N-0032642

Platform: Office 2013 or 2016 on Windows PC

Working professionals often have to organise and summarise mountains of data into presentable formats to identify key trends, offer comparisons and reveal patterns and relationships to answer some common questions such as sales performances for various regions, average class size per month and which factory is producing better?

In this one day lesson, you will find out how PivotTables reports make all these so easy by allowing anyone to compare, reveal, and analyse information by transforming different views of long lists of data into information that makes sense.

Who Should Attend

This course is intended for information workers such as decision makers, accountants, analysts and even sales managers who have frequent needs to analyse a large amount of business performance information such as sales figures and volume of production.

Course Duration

1 Day / 7 Hours

Course Outline

Creating a PivotTable

  • Specifying PivotTable Data
  • Adding fields
  • Rearranging fields
  • Changing a PivotTables Calculation

Filtering and Sorting a PivotTable

  • Filter a PivotTable
  • Sort a PivotTable

Working with PivotTable Layout

  • Adjust PivotTable Field List layout
  • Show/ Hide PivotTable elements
  • Layout group on the Design tab

Grouping PivotTable Items

  • Group dates or times
  • Group numeric items
  • Group other selected items
  • Ungroup item

Grouping PivotTable Items

  • Group dates or times
  • Group numeric items
  • Group other selected items
  • Ungroup items

Updating a PivotTable

  • Refresh PivotTable data
  • Change PivotTable data source

Formatting a PivotTable

  • Apply a built-in style
  • Work with style options

Creating a PivotChart

Using Slicers

  • Create a PivotTable Slicer
  • Filter data using a slicer
  • Format a slicer 
  • Delete a slicer
  • Sharing Slicers Between PivotTables 
  • Apply a slicer to another PivotTable

Certification Obtained and Conferred by

Certificate of Attendance from NTUC LearningHub


You must be able to use the keyboard/ mouse and be familiar with the Microsoft Windows Operating System. It is preferable that you also know the basics of Microsoft Excel.

Additional Note

PDUs for Maintaining PMP Credential 

This course is eligible for PDU Credits. Upon successful completion of this course, Project Management Professional (PMP) credential holders will be awarded 7 PDUs. Applicants need to access the PMI CCR System at to claim their PDU points with the following details:

Provider ID: 3163 

Activity ID: MSEDAPT

Activity Name: Data Analysis using Excel PivotTable

To view the full listing of courses that is eligible for PDU points, visit


Course Fee:

Full Course Fee

After Cat-C Funding for Company Sponsored

$2/hr Funding

Before GST

With GST

Funding Amount

Payable Fee Before GST

Payable Fee With GST






Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable
  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP). For more details on UTAP, click here

Company Sponsored

    • # This course is supported by SSG with Cat-C Funding and Company sponsored candidates (Singapore Citizens and PRs) are eligible for $2/hr funding. Price indicated above is after funding

  • Eligible Singapore Citizens can use their SkillsFuture credit to offset course fees. (Course ID: CRS-N-0032642)
  • Companies can claim $2/hr funding from SSG (SkillsConnect Reference Number: CRS-N-0032642)
  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) with Union Training Assistance Programme (UTAP). For more details on UTAP, visit

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.