Working with Pivot Tables
You can group data in a Pivot Table to show a subset of your data
To group data:
- In the Pivot Table, select the data you want to group.
- Right-click and select Group.
- The data appears as a new group.
PowerPivot is an add-on that you can use in Excel 2013 to perform more powerful data analysis.
To add PowerPivot:
- Select the FILE menu tab, and then select Options.
- In the Excel Options dialog box, on the right, select Add-Ins.
- From the Manage drop-down list, select COM Add-ins and then click Go.
- Check the Microsoft Office PowerPivot for Excel 2013 check box and click OK.
- The POWERPIVOT tab now appears on the Ribbon.
Once PowerPivot is installed, you can launch the PowerPivot window by selecting Manage from the POWERPIVOT tab. Here you can import and manage external data.
A new feature of Excel 2013 is the Relationships option on the DATA tab, in the Data Tools group.
To manage relationships in Pivot Tables, you must have at least two tables in your worksheet. Then, to create a relationship:
- From the DATA tab, select Relationships.
- In the Manage Relationships dialog box, select New.
- In the Create Relationship dialog box, enter the tables and columns you want to be related, and click OK.
- The information now appears in the Manage Relationships dialog box.