Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.

Read the tutorial on how to install Power Pivot in Excel 2010 here

Read the tutorial on how to enable Power Pivot in Excel 2013 here

So what is Power Pivot?

Power Pivot gives you the power to work with large sets of data.  In a nutshell, it allows you to use multiple data sources. Then you could import, merge and perform analysis on the resulting data. The beautiful thing with Power Pivot is it allows you to work on Big Data with no limitations.

Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access then build a Data Model from it. Then you can analyze these all into one awesome Pivot Table!

So how do I get my hands on this super awesome add-in…I hear you say?

The good thing with Power Pivot is it already comes with your Excel 2016, we need to enable it to start using Power Pivot.

You just need to make sure you have one of these versions:

Office 365 Pro Plus

Office 365 E3

Power Pivot is NOT AVAILABLE in Office 2016 for the following products:

Office 365 Home, Office 365 Personal, Office 365 Business Essentials, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E1


STEP 1: Go to File > Options 

Enabling in 2016 01

Enabling in 2016 02


STEP 2: Go to Add-Ins, for the Manage dropdown select COM Add-ins. Click Go once set.

Enabling in 2016 03


STEP 3: Check Microsoft Power Pivot for Excel. Click OK once done.

Enabling in 2016 04


STEP 4: You should now have the Power Pivot Tab.  Click Manage to see the Power Pivot Window.

Enabling in 2016 05


Power Pivot Window (click on the image to expand):

Enabling in 2016 06


Enabling in 2016




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Create a Treemap Chart With Excel 2016   Treemap Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month. The tree branches are represented by rectangles, wherein each rectangle's siz...
COUNTROWS in Excel Power Pivot   In Power Pivot, one of the major and more powerful feature are Measures. Measures (also known as Calculated Fields in Excel 2013) are formulas/calculations that are added to a Pivot Table. We will work on a simple example to show you how easy it is to use the COUN...
Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this example I show you how easy it is to insert a His...
Linking Excel Tables in Power Pivot   When you have multiple tables, Power Pivot can help you link them together. After linking them together you can then create a Pivot Table that will give you a single view of data. What we will focus on is a simple example of two Excel Tables: a Name Table and a Sales...