© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_15

15. Using PivotTables and PivotCharts

David Slager

(1)Fort Wayne, Indiana, USA

Few people use PivotTables but they are missing out on probably the strongest component in Excel. It takes a little time to learn, but once you have conquered it, you will become an Excel power user capable of grouping and summarizing data in almost any form you can think of. Your boss will be amazed at what you can produce. If you are the boss, you will be even more amazed at yourself. PivotTables can create the types of reports managers want to see: those that don’t contain every detail but rather contain only the data they want to see when they want to see it.

After reading and working ...

Get Essential Excel 2016: A Step-by-Step Guide 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.