Dashboards are useful to get a quick, visual status update on projects or drill down into important details, all in one place. They provide high-level view of work, based on complex data and simplifies visual nature so that users can make quick decisions.
Dashboards are made up of tables, charts, gauges, and figures. They can be used for any purpose (e.g. financial dashboard, project dashboard and so on). As Excel allows us to create tables, charts, carry-out complex calculations, data analysis and even scenario analysis, hence Excel can be used to create a Dashboard.
I use Dashboards in almost all of my projects as it involves working with data. So far i used Dashboards for sales analysis, receivables analysis, project management and so on. Usually i use the following components to create a dynamic, data-driven Dashboards in Excel:
Excel Dashboards look the followings. I would like to highlight that color combinations are very important nowadays to create Dashboards.
In the following articles i will discuss how to create a dashboard from scratch.