Excel Table Design

Best practice when creating tables for financial reporting

Excel Table Design Report DashboardsUse data tables when you want the reader to look up individual values and do exact one-to-one comparisons.

Data tables are ideal for effectively presenting different types of data – such as costs, quantities, ratios, etc. – all in one place.

 
excel table design

Let’s look at the best practices when designing tables.

Organize

Arrange your categories into two groups whenever it makes sense.

Items should have a clear sequence. If you’re not sure, always put yourself in your readers’ shoes.

When you present ratios, these should come right after your variables that feed that ratio.

excel table design reports

For presenting aggregated values, you should visually separate this from the rest of the data by either adding borders or colour.

excel table design reports

Focus on data

Keep the focus on your data by making the border and grid lines very subtle, or simply using white space for the grids between the data.

Use very subtle fill colour to assist the reader with horizontal scanning of values for larger data tables.

Format appropriately

Numbers should generally be right-aligned. This way the readers can compare the values with more ease than when they are centred or left-aligned.

excel table design reports

How you present large numbers, negative and positive values really depend on your country and the organisation you work for. Just do it the way your readers are used to seeing.

Text, on the other hand, should really be left-aligned. Here, we read from left to right. Sometimes, when the text is short, you might prefer to centre it, or right-aligned to fit your table better. Use your judgement here.

excel table design reports

The font should also be easy to read, so use simple fonts such as Arial or Verdana.

Use emphasis carefully

If you’d like to bring the reader’s attention to a certain number, you can use colour, or make it bold.

If you’d like to bring attention to a certain section of the table, especially when you do comparisons between one scenario and another, such as Actual against Budget, we can use symbols.

excel table design reports

Remember, don’t overemphasise and overdose on colour and symbols.

Keep your tables as simple as possible and bring attention only to areas that need attention most, which depends purely on the message that you want to communicate to your audience.

Watch the steps in this video:

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

GET 75% OFF THE COURSE
Free Ebook

Leave A Comment

Share This