PivotTables are most helpful for analyzing complex tables and data ranges (e.g., those with three or more columns, with at least one column containing multiple data types).Įach column in your data source becomes a PivotTable field, which summarizes its corresponding rows. PivotTables need first row column labels to determine how your data should be grouped. There are many advanced features related to PivotTables (e.g., PivotCharts and the PivotTable Options and Design tabs) which are beyond the scope of this document. NOTE: This document provides a brief overview of creating a PivotTable from existing data and using the PivotTable Field List to create different views of the data. A PivotTable report provides a dynamic summary of an existing table or data range that can be quickly expanded, collapsed, and rearranged to give you several different perspectives on your data. For this, Excel 2008 offers the PivotTable report, a powerful tool designed to perform this very task. When your Excel data range accumulates large amounts of mixed data, you need a way to identify the key trends and anomalies that exist deep within the data.
This article is based on legacy software. (Archives) Microsoft Excel 2007: Working with PivotTables Mac
