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.

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.