PowerPivot is a great tool for handling and reporting on data from a variety of sources. To use it, there a few steps that need to be taken first.
Depending on which version of Excel that you have, the process is different.
For Excel 2010, you first must download Microsoft PowerPivot from here and then install it. There are two versions available. You will need either the 32-bit or 64 bit version that matches the version of Excel that you have. Once you have downloaded and installed it, you’re done. The PowerPivot tab in Excel 2010 is automatically added. When you open up Excel you should be able to see the tab.
For Excel 2013 and Excel 2016, PowerPivot (changed to Power Pivot, notice the space now) is included with Excel, and just needs to be enabled.
To enable PowerPivot (or Power Pivot) for Excel 2013 and Excel 2016, just follow these steps:
First, click the File tab, then select Options.
Under Options, click Add-ins, and then choose COM Add-ins under Manage. Then click GO…
Lastly, check the box beside Microsoft Power Pivot for Excel, and then click OK.
The Excel Power Pivot tab will now be visible. Now you can go and do some really amazing things in Excel.