If you run Office 2013 Professional Plus, then as part of Excel 2013, you're
able to use PowerPivot and PowerView.
In this movie, I will show you how to enable PowerPivot in Excel 2013.
I'm using the Import sample file,
but we'll just be working in the Excel Options dialog box,
so no sample file is necessary;
you just need to have Excel 2013 open on your Desktop.
To enable the PowerPivot add-in, click the File tab.
Doing so displays the backstage view, and then click Options to open the
Excel Options dialog box.
Then click the Add-Ins category,
and at the bottom of that page of the Excel Options dialog box, click the
Manage Lists down arrow, click COM Add-ins -- that's COM for Common Object
Model -- and click Go.
Doing so displays the COM add-ins that are available to you.
Depending on your installation of Office 2013, you might not see all of these
add-ins, but the one you should see, and the box you need to check, is by what is
the second option in this list: Microsoft Office PowerPivot for Excel 2013.
And with that box checked, click OK, and you'll see a PowerPivot tab on the ribbon.
If PowerPivot doesn't appear when you follow this procedure, then open the
dialog box, and click the Add button.
Doing so displays another dialog box, within which you can click the PowerPivot file.
Click OK, and then click OK again to add the file to the dialog box, and also to the ribbon.
When you click that tab, you can see the controls that are available to you,
and I'll spend the rest of this chapter telling you how to use it.