O'Reilly logo

Formulas and Functions: Microsoft by Paul McFedries

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

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

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