Excel 2010 PowerPivot

Course Length: 1 day

Prerequisites: To ensure your success, we recommend you first take one of the following courses or have equivalent knowledge: Microsoft Excel 2010: Level 1, Microsoft Excel 2010: Level 2, and Microsoft Excel 2010: Level 3.

Course Content:
Lesson 1: Getting Started with PowerPivot
Topic A: Explore the PowerPivot Application
Topic B: Import Data from Various Data Sources
Topic C: Refresh Data from a Data Source
Topic D: Create Linked Tables

Lesson 2: Manipulating PowerPivot Data
Topic A: Organize and Format Tables
Topic B: Create Calculated Columns
Topic C: Sort and Filter PowerPivot Data
Topic D: Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports
Topic A: Create a PivotTable
Topic B: Create PivotCharts
Topic C: Filter Data Using Slicers
Topic D: Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot
Topic A: Manipulate PowerPivot Data Using DAX Functions
Topic B: Extract Data from Tables Using Functions
Topic C: Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data
Topic A: Protect Reports
Topic B: Save Reports in Different File Formats