Corporate Summary Excel Dashboard
The following Excel Dashboard displays a range of organisational metrics from revenue, expenses, FTE, Issues all against a "well thought out plan". The underlying data set is split over several sheets and the report updates via a slicer at the top of the Dashboard which allows it to spin by State. It is highly interactive and very user friendly and the cool part is you should be able to incorporate your own data into the dashboard easily.
This Excel dashboard has proven to be one of the most popular on the website. Let me know if you think it can be improved. My email is at the bottom of the 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