Microsoft Excel Power Pivot

Course Overview

Microsoft Excel Power Pivot

Analyse, manipulate and present data in pivot tables and pivot charts. 

Course Content

Module 1 - Pivot Table Revision 

• Creating a pivot table
• Presenting data using pivot charts
• Filtering pivot data with interactive slicers 

Module 2 - Getting Started and Connecting to Data Sources 

• Introducing Power Pivot and the Power Pivot interface
• Using the table import wizard
• Filtering data on import
• Creating queries to import data
• Adding data using copy and paste techniques
• Linking table data  

Module 3 - Related Data Sources 

• Creating additional queries
• Merge and append queries
• Creating relationships in Power Pivot
• Managing relationships
• Working in diagram view
• Defining hierarchy groups
• Producing related data outputs
• Adding queries to the data model
• Manipulating the data model  

Module 4 - Working with Power Pivot Formulas 

• Creating calculated columns
• Using Power Pivot functions
• Producing measures and KPIs
• Creating perspectives