Excel is a great tool. A great enough tool that almost 90% of analysts still use it for something or the other. It is not a renowned visualization tool but there are research firms who earns their bread and butter through primarily using excel for analysis.
Excel’s visualization capabilities has still a lot to catch up on but there are things which we consider standards which needs to be ported out to Web Dashboards.
Excel has a function where you can ‘bold’ a text. Actually almost all text editors or spreadsheet products out there has that feature where you can bold a text. This helps the user easily mark different sections in a dashboard.
Colors can be used to highlight key data. This is a feature which can help highlight key aspects in a web dashboard.
When you have a long list of tabular data, tracing data lengthwise becomes troublesome . This is another simple technique to help with easy reading of raw data in your dashboard. By the way, displaying raw data (without aggregation or filtering) is not recommended but there are cases when you do need to publish raw data.
Adding whitespace in Excel is easy. Insert a row !. If you enable this on your dashboard, this is another simple but powerful way to make your dashboard better looking.