Excel Tables: Best Practice to Create Tables for Financial Reporting in Excel
Sep 23, 2016 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com/
Excel Tables: Best Practice to Create Tables for Reporting in Excel Summary:
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.
Find more videos on charts here:
https://youtu.be/9y2OubgWhpE
https://youtu.be/cYHOezDL8SQ
https://youtu.be/FPxCKs4OlWE
https://youtu.be/5nf8rucx80E
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
-
8:03
Bearing
10 hours agoE-Safety Karen INVENTS Elon Musk HARASSMENT While LEAKING Private Details!
1.95K16 -
17:16
Clownfish TV
15 hours agoMedia Melting Down Over Mainstream Media Meltdown...
3.59K12 -
1:11
Gamazda
8 hours agoFlight of the Bumblebee - Rimsky-Korsakov
4.76K28 -
1:00:21
MYLUNCHBREAK CHANNEL PAGE
8 hours agoA Little Season in New York City
8.32K62 -
11:56
China Uncensored
10 hours agoThe Philippines Threaten War with China
6.63K11 -
33:00
Degenerate Jay
14 hours agoThe James Bond Games Have Been Lost To Time
3.61K2 -
29:11
The Why Files
1 day agoMystery in Cisco Grove: Don Shrum’s Encounter with UFOs, Aliens and Robots
18.1K20 -
2:26:44
Mally_Mouse
6 hours agoLet's Play -- Crowd Control Minecraft
18.7K4 -
2:19:18
The Quartering
11 hours agoTrump Mistrial Bombshell, RNC Plans For Trump In Jail & Maybe Some Video Games
51.7K137 -
3:10:32
SNEAKO
12 hours agoIs Trump a Criminal?
88.6K67