Mastering PivotTable with Microsoft Excel

Program Summary

Code: SAMPVT-1

Duration: 1-day

Who is this course for?

Our Microsoft Excel Mastering Pivot Tables course is suitable for those with a basic working knowledge of Pivot Tables who want a greater understanding of the more sophisticated functions and features available.

Prerequisites

Knowledge of Microsoft Excel Intermediate & Advance is essential with the follow pre-requisites:

• Able to switch between task applications
• Able to create simple to complex formulas and functions, like:

• COUNTIFS, AVERAGEIFS & SUMIFS Function
• IF Functions
• Nested Functions
• Database Function
• Able to clean Duplicate Records

Benefits

This course will provide a greater understanding of the functionality and potential of Pivot Tables.  You will be able to construct and manipulate summaries and analyzing data using Pivot Table. 

After completing this program, you will be able to perform the followings:

• Convert raw data to meaningful PivotTable reports
• Manipulate the PivotTable’s layout
• Create custom calculations and use the GetPivotData function
• Create an interactive Chart Title with a formula 
• Slice and dice your data with Slicer

Course Syllabus

Unit 1: What is Pivot Table? 

Unit 2: Sorting Pivot Table report

Unit 3: Applying filter to your Pivot report

Unit 4: Customizing your report layout

Unit 5: Creating custom calculation for your Pivot report

Unit 6: About GetPivotData Function

Unit 7: Grouping fields in Pivot Table

Unit 8: Slicing and dicing your Pivot Report (only available for Excel 2010, 2013 & 2016)

Unit 9: Converting Pivot Table to Graphic with Pivot Chart