Team Performace Excel Dashboard
The Team Performance Dashboard is a dashboard I created as a submission to the Excel Forum Dashboard competition in November 2014. The competition was open to all with a first prize of an iphone 6. There were over 100 entries in the dashboard competition. It was enjoyable putting together this Excel dashboard submission.
For a listing of all Excel Dashboards on the Smallman.com visit this link. There are more Excel files than you will be able to view!! 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.
The above Excel dashboard contains 8 interactive charts, 3 interactive tables and 1 static chart. The Excel dashboard is updated by a slicer at the top right of screen.
The following Excel Dashboard is added to show workings.