Excel Dashboards & Reports For Dummies
Book image
Explore Book Buy On Amazon

Table design is one of the most underestimated endeavors in Excel reporting. How a table is designed has a direct effect on how well an audience absorbs and interprets the data in that table. Unfortunately, putting together a data table with an eye for economy and ease of consumption is an uncommon skill.

For example, the table shown here is similar to many found in Excel reports. The thick borders, the variety of colors, and the poorly formatted numbers are all unfortunate trademarks of tables that come from the average Excel analyst.

A poorly designed table.
A poorly designed table.

You can improve on this table by applying these four basic design principles:

  • Use colors sparingly, reserving them only for information about key data points.

  • De-emphasize borders, using the natural white space between the components to partition your dashboard.

  • Use effective number formatting to avoid inundating your table with too much ink.

  • Subdue your labels and headers.

About This Article

This article is from the book:

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.

This article can be found in the category: