Curriculum
- 1 Section
- 5 Lessons
- 1 Day
Expand all sectionsCollapse all sections
- Topics5
- 1.1Getting 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.
- 1.2Manipulating 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.
- 1.3Creating 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.
- 1.4Using 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.
- 1.5Distributing 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.
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.
Prev
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.
Next