Analyzing Data Using a PivotTable

When you want to summarize information in a lengthy list using complex criteria, use the PivotTable to simplify your task. Without the PivotTable, you would have to manually count or create a formula to calculate which records met certain criteria, and then create a table to display that information. You can use the PivotTable layout to determine what fields and criteria you want to use to summarize the data and how you want the resulting table to look. You can create a PivotTable in a snap with the Quick Analysis tool (New!) or use the PivotTable button to have a little more control over the results. With this control, you can add multiple tables—either imported from a relational database from an external source ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.