Description

What Will Student Learn?

Getting Started with Power Pivot

This initial lesson shows students how to: explore the Power Pivot application, import data from sources, refresh data, and create linked tables.

Manipulating Power Pivot Data

Students will then move on to learning how to: organize and format tables, create calculated columns, sort and filter Power Pivot data, and create and manage table relationships.

Creating Power Pivot Reports

In this lesson, students build upon what they have learned by being shown how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually.

Using DAX Functions in Power Pivot

Here, students will learn how to: manipulate Power Pivot data using DAX functions, extract data from tables using functions, and work with time dependent data.

Distributing Power Pivot Data

This course wraps up with a look at how to protect data using both workbook and worksheet protection methods.  and how to save reports in different file formats.