Office 2013 In Depth

Working with PivotTables

PivotTables enable you to analyze and summarize table data. You can use an Excel PivotTable to create a report for a table that you created in a worksheet and you can also create a PivotTable from data that you import into an Excel worksheet, such as an Access database table or a table from another data source. A PivotTable can even be used to analyze data that you imported into Excel using Microsoft Query.

An Excel PivotTable is called a PivotTable because it enables you to arrange table data in a cross-tabulated report. You can pivot or rearrange the information in the PivotTable to analyze the data it contains. You not only determine which table fields are used as row and column headings in the PivotTable, but you ...