Power Pivot is an add-in you can use to perform powerful data analysis in Excel. The add-in is built into certain versions of Excel, but by default, it's not enabled.

Explore the PowerPivot application, import data from sources, refresh data, and create linked tables.
Students will then move on to learning how to: organize and format tables, create calculated columns, sort and filter PowerPivot data, and create and manage table relationships.
After building your table data learn how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually. Then, manipulate PowerPivot data using DAX functions, extract data from tables using functions, and work with time dependent data.
Wrap up with a look at how to protect reports and how to save reports in different file formats.

Course Outline

Lesson 1: Getting Started with PowerPivot

Lesson 2: Manipulating PowerPivot Data

Lesson 3: Creating PowerPivot Reports

Lesson 4: Using DAX Functions in PowerPivot

Lesson 5: Distributing PowerPivot Data

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
202 Church Street S.E. , Suite 203 Leesburg, VA 20175
800-453-596 (Toll Free)