Microsoft Excel 2010 PowerPivot

Course 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.
1 day
Contact us for pricing

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

Advanced ExcelExcel 2010Microsoft Excel 2010