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 2016 here

So what is Power Pivot?

In a nutshell, Power Pivot allows you to use multiple data sources for analysis.

Power Pivot gives you the power to work with large sets of data that are over 1 millions rows!!!

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 and analyzing 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 2013, we need to enable it to start using Power Pivot.

You just need to make sure you have Office Professional Plus 2013 as either:

Office 365 ProPlus Subscription or

Excel 2013 Standalone Download


STEP 1: Go to File > Options 

enabling 2013 01

enabling 2013 02


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

enabling 2013 03


STEP 3: Check Microsoft Office PowerPivot for Excel 2013. Click OK once done.

enabling 2013 04


STEP 4: You should now have the Power Pivot Tab in your ribbon menu.





Enabling in 2013




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

Using Measures in 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 add your fir...
Using Excel Tables in Power Pivot To be able to use Power Pivot, you need to have data imported into the Power Pivot Window first. If your data is in the normal Excel worksheets, then you will not be able to use this data in Power Pivot. Fortunately there are a lot of possible ways Power Pivot can retrieve ...
Importing Excel Workbooks in Power Pivot   Power Pivot is a very powerful analytical tool which allows you to import data from various external sources! This opens up many possibilities and gives you the power to do further data analysis and get insightful business metrics. You can import data from the fol...
Power Pivot is now available in all versions of Ex... Microsoft have just announced that Excel Power Pivot will now be available in all Windows editions of Excel, which is awesome news and a step in the right direction. Here is what they announced: I’m happy to announce that your input has had another direct impact on the produc...