Course Length: 1-day
Course Overview
This course takes a look at the free PowerPivot add-in for Microsoft Excel. Its aim is for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data.
Prerequisites
- General Excel and Report building skills
- Pivot Tables
- Excel - Data Analysis and Forecasting
- Or Equivalent Knowledge
Course Outline
Getting Started with PowerPivot
- Enable and Navigate
- Import Data from Various Data Sources
- Refresh Data from a Data Source
- Create Linked Tables
Manipulating PowerPivot Data
- Organize and Format Tables
- Create Calculated Columns
- Sort and Filter PowerPivot Data
- Create and Manage Table Relationships
Creating PowerPivot Reports
- Create PivotTables
- Create PivotCharts
- Filter Data Using Slicers
- Present PivotTable Data Visually
Using DAX Functions in PowerPivot
- Manipulate PowerPivot Data Using DAX Functions
- Extract Data from Tables Using Functions
- Work with Time-Dependent Data
Distributing PowerPivot Data
- Protect Reports
- Save Reports in Different File Formats