heading

blog-img

Microsoft Excel - Dashboard

Introduction

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.

Components of Dashboards

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.

My experience

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 Table
  • Formula and functions
  • Pivot-tables
  • Slicers
  • Charts
  • Shapes
  • Conditional formatting
  • Drop-downs and
  • Macros

Samples

Excel Dashboards look the followings. I would like to highlight that color combinations are very important nowadays to create Dashboards.

dashboard 1 dashboard 2 dashboard 3 dashboard 4

In the following articles i will discuss how to create a dashboard from scratch.


Recent Posts
Top tags
  • Business

  • Corporate

  • Finance

  • Excel