Creating a PivotTable
If your worksheet contains extensive data, you can summarize it using a PivotTable report. For example, say you have a worksheet that lists every sale by product and customer over the past four quarters. You could use a PivotTable to summarize sales by product, customer, or quarter.
Select the data you want to analyze in your PivotTable.
On the Insert tab, click the Recommended PivotTables button.
In the Recommended PivotTables ...
Get Easy Office 2013 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.
