Microsoft Excel 2010 PowerPivot

Request more details:

This course is for participants with a sound working knowledge of Microsoft Excel 2010, particularly those who will be using Excel to make business decisions.
To ensure your success, we recommend you first take at least our Excel Intermediate course, but ideally Advanced or have equivalent knowledge.
Course Objective:
Upon successful completion of this course, students will be able to:

become familiar with the PowerPivot application and import data.
manipulate data in a PowerPivot worksheet.
create reports using PowerPivot data.
use DAX functions in PowerPivot.
distribute PowerPivot Data.
Getting Started with PowerPivot:
Explore the PowerPivot Application
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 a PivotTable
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