Skip to content Skip to site navigation Skip to service navigation

Introduction to Excel PowerPivot

New session times will be displayed below upon confirmation.

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

Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of new discoveries and improvement.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.