Get started with Power Pivot in Microsoft Excel

Get started

• Learn more about data analysis tools in Excel

• Power Pivot: Powerful data analysis and data modeling in Excel

• Start the Power Pivot add-in

• Keyboard shortcuts in Excel

Data Modeling and Visualization Tutorials

• Tutorial: Import Data into Excel, and Create a Data Model

• Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX

Understand the Power Pivot Data Model

• Create a Data Model in Excel

• Create a memory-efficient Data Model using Excel and the Power Pivot Add-in

• When to use Calculated Columns and Calculated Fields

• Data Model specification and limits

• Data types in Data Models

• Freeze columns

Add Data

• Get data using the Power Pivot add-in

  • Get data from Analysis Services

  • Import Data from a Reporting Services Report

  • Make changes to an existing data source in Power Pivot

• Find out which data sources are used in a workbook data model

• Filter the data you import into Power Pivot

• Create a blank table in Power Pivot

• Refresh imported data in Power Pivot

• Troubleshoot linked tables

  Tip: Power Query for Excel is a new add-in you can use to import data from many different source into your Excel workbooks and data models. Learn more at Microsoft Power Query for Excel Help.

Work with Relationships

• Create a relationship between tables in Excel

• Create relationships in Diagram View in Power Pivot

• Delete relationships between tables in a Data Model

• Troubleshoot table relationships

• Work with Relationships in PivotTables

Work with Hierarchies

• Hierarchies in Power Pivot

Work with Perspectives

• Perspectives in Power Pivot

Work with Calculations and DAX

• Understanding Calculations in Power Pivot

• When to use Calculated Columns and Calculated Fields

• Calculated Columns in Power Pivot

  • Create a Calculated Column in Power Pivot

• Calculated Fields (aka Measures) in Power Pivot

  • Create a Calculated Field in Power Pivot

• Key Performance Indicators (KPIs) in Power Pivot

• Lookups in Power Pivot Formulas

• Aggregations in Power Pivot

• Recalculate Formulas in Power Pivot

• DAX in Power Pivot

  • Quick Start: Learn DAX Basics in 30 Minutes

  • Context in DAX Formulas

  • Filter Data in DAX Formulas

  • DAX operators

  • DAX Function Reference

Work with Dates and Time

• Dates in Power Pivot

• Understand and create date tables in Power Pivot in Excel

• Time Intelligence in Power Pivot in Excel

• Filter dates in a PivotTable or PivotChart report

Errors and Messages

• Power Pivot error: Maximum Memory or File Size Exceeded

• Power Pivot error: “Initialization of the data source failed

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.