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