Excel Dashboards and Reports For Dummies, 2nd Edition

Chapter 3

Dressing Up Your Data Tables

In This Chapter

The principles of table design

Custom number formatting

Applying custom format colors

Applying custom format conditions

The Excel table is the perfect way to consolidate and relay information. Data tables are very common — you’ll find one in any Excel report. And 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 ...