Skip to Main Content
Excel Dashboards & Reports For Dummies, 4th Edition
book

Excel Dashboards & Reports For Dummies, 4th Edition

by Michael Alexander
April 2022
Beginner to intermediate content levelBeginner to intermediate
384 pages
9h 47m
English
For Dummies
Content preview from Excel Dashboards & Reports For Dummies, 4th Edition

Chapter 3

The Pivotal Pivot Table

IN THIS CHAPTER

Bullet Introducing pivot tables

Bullet Building your first pivot table

Bullet Customizing your pivot tables

Bullet Using pivot-driven reports

Bullet Creating top and bottom reports

I know what you’re thinking: “Am I supposed to be jumping right in with pivot tables?” My answer is an emphatic yes!

In Chapter 2, I introduce the concept of reporting models that separate the data, analysis, and presentation layers. As you discover in this chapter, pivot tables lend themselves nicely to this concept. With pivot tables, you can build reporting models that not only are easy to set up, but can also be refreshed with the simple press of a button. Then you can spend less time maintaining your dashboards and reports and more time doing other useful things. No utility in the whole of Excel allows you to achieve this efficient data model better than a pivot table.

Pivot tables have a reputation for being complicated, but if you’re new to pivot tables, relax a bit. After reading ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Dashboards and Reports for Dummies, 3rd Edition

Excel Dashboards and Reports for Dummies, 3rd Edition

Michael Alexander

Publisher Resources

ISBN: 9781119844396Purchase Link