Consulting Firm Revenue & Expense Excel Dashboard
The following Excel dashboard has plan V actual, an interesting radar chart and analysis by region. It uses Excel’s excellent built in conditional formatting traffic light feature. It does not display as much information as some of the other dashboards on the smallman.com but I like it for its simplicity and with only two colours (excluding the traffic light feature). At this stage this is the only Excel dashboard on the site where I have used only 2 colours. Most Excel dashboards on the site have 3 or 4 colours on each page
The Excel dashboard is just one of many on TheSmallman.com. Many different Excel dashboards to choose from with a range of different metrics. However, the sample should give you insight into what is possible with Excel. Excel dashboard creation should be fun and creative, be consistent with your colours, try to align elements of your dashboard, group like items together to ensure flow and get others involved in the process. Group think always produces a more informed outcome.
I am starting a YouTube channel to demonstrate some of the visual aspects on thesmallman.com and to outline automation. My page can be found here. Smallman on YouTube
The following Excel dashboard is an Excel 2010 file and the features on the main dashboard page will not work in earlier versions of Excel.
