Key Organisational Metrics Report

Description
The attached Excel dashboard has plan & actual and a range of organisational metrics that can easily be adjused to meet your needs. The data is well laid out with the separation of inputs, calculations and outputs. It has an interesting radar chart and analysis by region with the abiliy to change the region with a slicer. 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).  

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.

To find and benefit from more downloadable Excel tools from The Smallman, please visit my channel page where you can find an even broader range of metrics and dashboards.

If you have any questions regarding this tool, don’t hesitate to reach out by starting a discussion below or private messaging directly through my Eloquens author channel.