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 enable Power Pivot in Excel 2013 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?


Get Office 2010 Home & Business on Amazon

Office 365 ProPlus Subscription


STEP 1: The first step is to check the Excel bit version that you have on your PC.

To check the bit version, you need to go and open any Excel workbook and go to File > Help and on the far right hand side you will see the Version and the bit number in brackets, either (32-bit) or (64-bit).  Once you know this, close out of Excel completely!

excel 2010 file help


STEP 2: You will need to click on the following link and download the Power Pivot add-in from Microsoft’s website:

Download Power Pivot for Excel 2010

installing 2010 02


STEP 3: Press the Download button and you will need to select the download bit version based on the bit system your Excel 2010 version is running (from Step 1).

If your Excel is 32-bit, pick the x86 installer.

If your Excel is 64-bit, pick the amd64 installer:

installing 2010 03

Press the NEXT button…

installing 2010 04

…and this will start the download of the add-in installer .msi file installer on your browser (if you do not see this, go to your browser’s Downloads folder).


STEP 4: Click on the .msi file to run the installer:

installing 2010 05


STEP 5:  This will bring up the Microsoft Power Pivot for Excel Setup:

installing 2010 06


Click the Next button and accept the terms of the Licence Agreement and press Next again:

installing 2010 07


Click Next and select the Install button, wait for the Install to finish:

installing 2010 08


You will get the following message once your install has been completed successfully.  Press Finish!

installing 2010 09


STEP 6: Open a blank Excel workbook and on the ribbon menu you should now see the Power Pivot tab:

installing 2010 10



Install Power Pivot for Excel 2010




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 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 ...
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...
Using the Diagram View in Power Pivot   Have you gotten overwhelmed with the amount of Tables whenever you used Power Pivot? As I got accustomed to Power Pivot, my data model expanded and the number of relationships connecting these Tables together grew to a larger amount. Fortunately, Power Pivot has t...
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...