Microsoft Excel 2010 PowerPivot

Request more details:

Description:
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.
Prerequisites:
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