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 5

Dressing Up Your Data Tables

IN THIS CHAPTER

Bullet The principles of table design

Bullet Custom number formatting

Bullet Applying custom format colors

Bullet Applying custom format conditions

The Excel table is the perfect way to consolidate and relay information. Data tables are quite common — you’ll find one in any Excel report. Yet the concept of making tables easier to read and more visually appealing escapes most of us.

Maybe it’s because the nicely structured rows and columns of a table lull us into believing that the data is already presented in the best way possible. Maybe the options of adding color and borders make the table seem nicely packaged. Excel makes table creation easy, but even so, you can use several design principles to make your Excel table a more effective platform for conveying your data.

In this chapter, you explore how easy it is to apply a handful of table design best practices. The tips found here ultimately help you create visually appealing tables that make the data within them easier to consume and comprehend.

Table Design Principles

Table design is one of the most ...

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