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