Power Pivot Help

Power Pivot provides advanced data modeling features in Microsoft Excel 2013. Use the resources below to learn about how you can use Power Pivot to help you gain new insights into your data.

Get started

Partner Features

Power Pivot Tutorials

Understand the Power Pivot Data Model

Add Data

 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

Work with Hierarchies

Work with Perspectives

Work with Calculations and DAX

 Tip    The DAX Resource Center Wiki on TechNet provides an extensive number of articles, videos, and examples from BI experts.

Work with Dates and Time

Work with Power View

Share your workbook

Errors and Messages

Applies to:
Excel 2013, Power Pivot in Excel 2013