Excel 2016: Using the Power Pivot Add-in
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.
Expected Duration (hours)
1.0
Lesson Objectives Excel 2016: Using the Power Pivot Add-in
Activating Power Pivot
Using the view settings in Power Pivot
Importing your database
Creating Power Pivot relationships
Customizing your Power Pivot tables
Applying data formats in Power Pivot tables
Sorting the data in your Power Pivot table
Filtering data in your Power Pivot table
Creating a calculated field in your Power Pivot table
Creating custom views in your Power Pivot table
Updating your Power Pivot tables
Creating an advanced PivotTable
Creating an advanced PivotChart
Creating a dashboard
Course Number: ds_msex2016_14_enus
Expertise Level
Expert