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.
Cost: Price on application
Duration: 1 day
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
To ensure your success, we recommend you first take at least our Excel Intermediate course, but ideally Advanced or have equivalent knowledge.
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
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:
Save Reports in Different File Formats