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

In the following sections, you’ll find additional resources and tutorials that go into detail about how to use Power Pivot, and how it can be combined with Power Query and Power View to perform …

How to use Power Pivot in Excel to perform data analysis and create sophisticated data models using data from various sources to see hidden patterns and trends.

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn …

Power Pivot in Microsoft Excel is an add-in you can use to perform powerful data analysis in Excel. Here’s how you enable Power Pivot before you use it for the first time.

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

The sales manager at Adventure Works wants to create a PivotTable she can use to quickly display whether or not sales employees are meeting their sales quota for a specific year.

Many data analysis and modeling problems in Power Pivot can be solved by using calculations. There are two types of calculations in Power Pivot, calculated columns and measures.

Within Excel, Data Models are used transparently, providing data used in PivotTables, PivotCharts, and Power View reports. You can view, manage, and extend the model using the …