Training: Excel – PowerPivot

Module 1: Introduction to PowerPivot 

• Adding the PowerPivot Add-In to Excel
• Introduction to PowerPivot

Module 2: PowerPivot Data Sources 

• Importing Excel and Access files
• Importing CSV files

Module 3: Creating Reports with PowerPivot 

• Creating Pivot Tables
• Modifying the Pivot Table Structure
• Setting up row, column, page and data fields
• Creating grouping criteria
• Creating calculated fields
• Automatic sorting and filtering
• Using segments
• Formatting the pivot table
• Pivot charts

Module 4: Performance Indicators (KPI) 

• Creating a calculated field
• Creating a KPI
• Modifying a KPI
• Use in pivot tables

Module 5: Advanced DAX functions

• Using DATE and TIME functions
• Using STATISTICAL functions
• Using VALUE functions
• Using LOGICAL and INFORMATION functions
• Using TEXT functions