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, 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
Categories
More Information
  • (Local Institution) NTUC LearningHub
  • No comments yet.
  • Add a review
    error: Content is protected !!