Excel 2013: The Power Pivot Add-in
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Power Pivot allows you to create advanced PivotTables and PivotCharts in Excel 2013. Discover how to work with Power Pivot, so you can analyze data from a variety of sources.
Expected Duration (hours)
1.1
Lesson Objectives Excel 2013: The Power Pivot Add-in
Activating Power Pivot
Importing your database
Creating Power Pivot relationships
Formatting 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_msex2013_15_enus
Expertise Level
Expert