Best Practice to Create Tables for Financial Reporting in Excel

Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Use Excel data tables when you’d like the reader to lookup individual values and do exact one to one comparisons. Follow these best practices for optimum data table design in Excel:
1. Organize - arrange your categories into groups whenever it makes sense. Items should have a clear sequence. If you're not sure, put yourself in your readers shoes. If you have ratios presented, these should come right after your variables that feed the ratio. If you are showing aggregated values, you should visually separate this from the rest of the data by either adding borders or color to distinguish it from the rest.
2. Focus on data - Keep the focus on your data by keeping the table borders and grids very subtle. Or simply use white space for the grids between data. Use very subtle fill color to assist the reader with horizontal scanning of values for larger data tables.
3. Formatting - Numbers should be right aligned. This way the reader can compare the values with more ease than when they are centered or left aligned. Text on the other hand should generally be left-aligned. Sometimes though when the text is short, you might prefer to center or right align it to fit your table better - so use your judgment here. How you present large numbers, negative and positive values really depend on your country and the organization you work for - i.e. what your readers are used to seeing. Text font should be easy to read, such as Arial or Verdana.
4. Emphasis - If you’d like to bring the readers attention to a certain number, you can use color or change it’s format to bold. If you’d like to bring the attention to a certain section of the table, especially when doing comparisons between one scenario to another, such as budget against actual, you can use symbols.
🌍 My Online Excel Courses ► www.xelplus.co...
Find more videos on charts here:
• How to Improve your Ch...
• How to Create Dynamic ...
• Create a Dynamic Budge...
• How to Create Panel Ch...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
#excel

[@maherahmad6982]

This is what I was truly looking for as I am working in the Finance - you are great

[@automationguide3498]

These tips will really help me a lot.
I always struggled with designed tables. no matter, how good am i designing charts.
Thank You !!

[@LeilaGharani]

Glad to hear that.

[@youtubeuser8232]

I don't understand the problem with horizontal lines: for me it's' very difficult to read tables without them because I find difficult to follow the "invisible" horizontal line.
Fox example, I find the automatic formatting of Excel Tables extremely easy to read.

[@davegoodo3603]

Hi Leila, very interesting video. I wonder if you have more videos coming up on Tables (not pivot) and also Structured References, I have found these confusing.. Maybe I could make this as a suggestion for a future video?
Thanks
Dave

[@hosseinhosseinpoor4845]

Thanks leila.