Microsoft Excel Courses - PowerPivot

Introducing PowerPivot

• Installing the PowerPivot Add-in
• Looking at the Data Model window

Importing Data

• Importing data from multiple sources
• Creating relationships between tables

Creating PivotTables

• Creating a PivotTable with PowerPivot
• Using the Field List
• PowerPivot and Excel PivotTables compared

Creating a Date Table

• Grouping Dates in PivotTables
• Using Year and Month Columns
• How to use Date filters

Filtering Data with Slicers

• Using slicers to filter data
• Using slicers across multiple PivotTables

PivotCharts and Dashboards

• Using Charts and slicers to create interactive dashboards

Introducing PowerView

• A brief overview of PowerView