Excel Powerpivot – Class Outline
Lesson 1: Getting Started with PowerPivot
- Topic 1A: Explore the PowerPivot Application
- Topic 1B: Import Data from Various Data Sources
- Topic 1C: Refresh Data from a Data Source
- Topic 1D: Create Linked Tables
Lesson 2: Manipulating PowerPivot Data
- Topic 2A: Organize and Format Tables
- Topic 2B: Create Calculated Columns
- Topic 2C: Sort and Filter PowerPivot Data
- Topic 2D: Create and Manage Table Relationships
Lesson 3: Creating PowerPivot Reports
- Topic 3A: Create a PivotTable
- Topic 3B: Create PivotCharts
- Topic 3C: Filter Data Using Slicers
- Topic 3D: Present PivotTable Data Visually
Lesson 4: Using DAX Functions in PowerPivot
- Topic 4A: Manipulate PowerPivot Data Using DAX Functions
- Topic 4B: Extract Data from Tables Using Functions
- Topic 4C: Work with Time Dependent Data
Lesson 5: Distributing PowerPivot Data
- Topic 5A: Protect Reports
- Topic 5B: Save Reports in Different File Formats