Managing Your Data with Excel Dashboard

 

Do you spend too much time updating your Excel reports every month?
Do you spend hours collating data, creating tables and charts, but the outcome does not make sense?

If your answers are YES for these questions, it is time for you to upgrade your skills in creating interactive charts and tables with Excel Dashboard that will impress your boss, and at the same time, take your career to the next level!

 

 

What is Excel Dashboard?

Excel Dashboard is a visual interface that provides at-a-glance views into the key measures that are relevant for a particular objective or business process. It can be used to present critical data on key business performance areas in a summarised manner. Excel Dashboards are able to capture the readers’ attention by transforming raw numbers into visually rich charts and tables – giving valuable insights into the key performance indicators of the business. As a result, the management can quickly make appropriate decisions.

 

Here are some of the important attributes that should be considered when creating an Excel Dashboard:

  • Present data to make it easy for readers in reading and understanding.
  • Display data with graphical elements and provide visualisations that aid in focusing on key trends, comparisons, and exceptions.
  • Display data that are only related to the dashboard’s goals.
  • Label every Chart and Table in the dashboard clearly for ease of reference.
  • Is interactive and provides functionality such as filtering and drill downs.

 

Excel Dashboard report can be applied in any industries for its dynamic functions by incorporating some calculations and techniques. It is important to use proper dashboard design which will make complex data to be simplified, as well as summarising a company’s progress in a more interesting presentation. The figure below shows an example on the transformation of the data from aggregated data into a dashboard presentation.

 

 

 

Dashboards can be categorised based on their utility as follows:

 

i. Strategic Dashboards: Track Key Performance Indicators (KPIs).

 

 

ii. Analytical Dashboards: Process data to identify trends.

 

 

iii. Operational Dashboards: Track current performance of key metrics and KPIs.

 

 

iv. Informational Dashboards: summarise data to focus on changes and exceptions.

 

 

By Yugini Vellu  | Google | LinkedIn

 

 

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
64-2, Jalan Puteri 2/2, Bandar Puteri Puchong, 47100 Puchong Selangor, Malaysia. Tel: 603-80684461
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka. Tel: 606-2835955
Instant SSL