Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Using Pivot Tables
Figure 14-4: The Filter area allows you to easily apply filters to your pivot table, focusing on specific data items.
Creating the basic pivot table
Now that you have a good understanding of the structure of a pivot table, follow these steps to
create your first pivot table.
You can find the example file for this chapter on this topic’s companion website at www.
wiley.com/go/exceldr in the workbook named Chapter 14 Samples.xlsx.
On the Web
1. In the Chapter 14 sample file, go to the tab called Sample Data and click any single cell inside
the source data (the table you’ll use to feed the pivot table).
2. Click the Insert tab on the Ribbon.
Find the PivotTable icon, as shown in Figure 14-5.
3. From the drop-down list under the PivotTable icon, select PivotTable.
Figure 14-5: Start a pivot table by clicking the PivotTable icon found on the Insert tab.