Advanced and Analytical Techniques with Pivot Tables

Overview:

This on-demand course is builds on a viewers basic knowledge of Pivot Tables. It is intended for those who are already familiar with the process of creating and configuring Pivot Tables and provides content to take their proficiency to the next level. The course will cover concepts that can be used to obtain a variety of analytical results from data using various techniques and involves Pivot Tables as well as Pivot Charts. 

Course Content:

In this course, you will gain knowledge about the following topics:  

• Working with Custom Lists for Pivot Tables 
• Exploring analysis with multiple Field instances 
• Working with Pivot Table Grouped Fields 
• Understanding Formula Fields and distinguishing Calculated Items and Fields 
• Combining Analytical Techniques and working with Pivot Charts 

Learning Objectives:

Upon completing this course, you will be able to:

• Learn how Fields can be used to get multiple analysis from Pivot Tables
• Learn how Pivot Charts can augment Pivot Table analysis
• Get a grounding on Pivot Table formulas and when to use which 

Who Will Benefit: 

Those who have a working knowledge of Pivot Tables and want to take their proficiency to the next level for analysis and reporting.