Banking Dashboard Excel
The following Excel dashboard has been used in the financial modelling document. It is a dashboard which outlines banking highlights for a fictitious bank. It uses a spinner button to generate projections which are highlighted in blue on the right to indicate that these figures are budget. The item to appear in the main (Red) graphical display are chosen from a group of Radio Buttons. There is a combo box which enables a choice of region or department and some detail around the key highlights for banking measures on the left of the dashboard.
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! 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.
There is something for everyone and so many different varieties. The link to the dashboard section is as follows:
A recently updated version of the above banking dashboard has been completed, the file will look like the above.
To dashboard has a clean consistent design where only two colour variants have been used (blue and red). Alignment is used to ensure that the eye moves from element to element quite quickly, symmetry is helpful for this purpose. Additional information around absenteeism which compares last year to the current year is added as well as new hires and terminations.
The following is the Excel Dashboard is an Excel 2010 macro enabled workbook. Please NOTE: as it's format is XLSM, some firewalls prevent access.
