14. Analyzing Data with PivotTables

Tables and external databases can contain hundreds or even thousands of records. Analyzing large amounts of data can be a nightmare without the right tools. To help you, Excel offers a powerful data analysis tool called a PivotTable. This tool enables you to summarize hundreds of records in a concise tabular format. You can then manipulate the layout of the table to see different views of your data. This chapter introduces you to PivotTables ...

Get Formulas and Functions: Microsoft® Excel 2010 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.