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
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
Categories
More Information
- (Local Institution) NTUC LearningHub
Add a review