Page 714 - Excel 2013 All-in-One For Dummies

696 Using the PowerPivot and Power View Add-Ins
having to download the add-in from the Microsoft Office website, you can start using PowerPivot simply by activating the add-in as follows:
1. Choose File➪Options➪Add-Ins or press Alt+FTAA.
Excel opens the Add-Ins tab of the Excel Options dialog box with Excel
Add-Ins selected in the Manage drop-down list.
2. Click the Manage drop-down list button and then select COM Add-Ins from the drop-down list before you select the Go button.
Excel displays the COM Add-Ins dialog box that contains (as of this writing) three COM (Component Object Model) add-ins: Inquire Add-in, Microsoft Office PowerPivot for Excel 2013, and Power View.
3. Select the check box in front Microsoft Office PowerPivot for Excel 2013 and then click OK.
Excel closes the COM Add-Ins dialog box and returns you to the Excel 2013 worksheet window that now contains a PowerPivot tab at the end of the Ribbon.
Keep in mind that the Excel PowerPivot add-in is available in Office 2013 Professional Plus edition as well as all editions of Office 365, except for Small Business. However, PowerPivot is not supported in Excel 2013 running on the RT version of the Microsoft Surface tablet. Sorry, but you have to have the Microsoft Surface tablet with Windows 8 Pro in order to install and use the PowerPivot add-in.
Data modeling with PowerPivot
PowerPivot makes it easy to perform sophisticated modeling with the data in your Excel pivot tables. To open the PowerPivot for Excel window, you click the Manage button in the Data Model group on the PowerPivot tab shown in Figure 2-16 or press Alt+BM.
If your workbook already contains a pivot table that uses a Data Model cre- ated with external data already imported in the worksheet (see Book VI, Chapter 2 for details) when you select the Manage button, Excel opens a PowerPivot window similar to the one shown in Figure 2-17. This window contains tabs at the bottom for all the data tables that you imported for use in the pivot table. You can then review, filter, and sort the records in the data in these tables by selecting their respective tabs followed by the appropriate AutoFilter or Sort command button. (See Book VI, Chapter 1 for details.)