Chapter 3

Dressing Up Your Data Tables

In This Chapter

arrow The principles of table design

arrow Custom number formatting

arrow Applying custom format colors

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

Get Excel Dashboards and Reports For Dummies, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.