Starting PowerPivot in Microsoft Excel 2013
Starting PowerPivot in Microsoft Excel 2013: Video
This video shows starting PowerPivot in Excel 2013. For the complete course click here.
Starting PowerPivot in Excel 2013: Overview
PowerPivot is an add-in that is included in Microsoft Excel Professional Plus 2013. It was also available in Excel 2010, but has seen many improvements to its functionality in the 2013 version. PowerPivot is not available in Excel 2007. PowerPivot essentially expands the abilities of the Excel data model to allow for robust data management and reporting for PivotTables and PivotCharts.
Before you can begin using PowerPivot, however, you must enable it within Excel. PowerPivot is an “Add-in” program that must be enabled within Excel before you can use it. To enable PowerPivot, click the “File” tab in the Ribbon to open the backstage view. Then click the “Options” category at the left side of the backstage view to open the “Excel Options” window. Within this window, click the “Add-Ins” category shown at the left side. At the bottom right side of this window, select “COM Add-ins” from the “Manage” drop-down and then click the “Go…” button to open the “COM Add-Ins” window. Check the checkbox for the “Microsoft Office PowerPivot for Excel” add-in, and then click the “OK” button to the right to enable the add-in.
At this point, you should see a new “PowerPivot” tab appear within the Ribbon. You can click this tab within the Ribbon to view the commands used to mange your PowerPivot data within Excel.