O'Reilly logo

Office 2013 In Depth by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required