Skip to content Skip to site navigation Skip to service navigation

Introduction to Excel PowerPivot

Class Code


Class Description

Learn PowerPivot and how it brings Excel closer to relational database functionality. In the PowerPivot Data Model you define tables and relationships, and enables business intelligence analytics far deeper than anything previously available in Excel.

Note: This class is meant for Windows Excel users only. The PowerPivot functionality is NOT available for the MacOS platform.

Course outline/topics:

What is PowerPivot?
  - 50 million rows of data -- in Excel?
  - A data model, new analytical functions and PivotTables

Building a data model
  - Creating, importing and linking to tables
  - Defining table relationships
  - DAX functions

Creating PivotTables from the data model
  - Simple PivotTables
  - PivotTables with multiple source data tables
  - VLOOKUP-like functionality in PivotTables
  - Meaningful calculated fields in PivotTables

Technical considerations with PowerPivot
  - Installing the PowerPivot Add-in
  - Issues with very large tables
      - System memory
      - MS Office version requirements
      - 32-bit vs 64-bit Office

Who should attend this course?
PowerPivot is an advanced topic. You will likely find this course useful if:

- You are an experienced Excel Power User
- You use and are comfortable creating and working with PivotTables
- You are comfortable using Excel tables, including using table structured references in formulas
- You analyze very large datasets and are looking for new, powerful tools

University IT Technology Training classes are only available to Stanford University staff, faculty, students, and Stanford Hospitals & Clinics employees, including Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health. A valid SUNet ID is needed to enroll in a class.