Course Overview
This course takes a look at the free Power Pivot add-in for Microsoft 365 Excel. Its aim is for all users of Power Pivot to get a good grasp of how it works and its feature set. It covers different features of the interface, techniques for manipulating and visualizing Power Pivot data, how to create Power Pivot reports, the structure of DAX functions, and ways to distribute Power Pivot data.
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.
Instructor
