Full program description

Data Analysis using Excel PivotTable

What's In It For Me

  • Creating a pivot table
  • Working with PivotTable Layout

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 organize and summarize 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, students 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

Pre-requisites

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

Funding Information

  • 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)

Price

Course Fee:

Individual Sponsored

Company Sponsored

w/o GST

w GST

w/o GST

w GST

Original Course Fee

$165.00

$176.55

$165.00

$176.55

Promotional Course fee (until 31 Dec 2017)

$135.00

$144.45

$135.00

$144.45

Fee payable

$135.00

$144.45

$121.00

$130.45

Remarks:

  • 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.
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

MSEDAPT