How To Make Business Dashboards

With Excel

What is A Dashboard?

• Dashboard is a type of Business Reporting that presents critical data of different key performance areas in a summarized manner, just like a car dashboard. This helps management to respond quickly with a better decision.

How To Make A Cool Business Dashboard With Excel?• There are a number of tools available now-a-

days in market, which allow you to create Business Dashboards. However, the best choice for making Business Dashboard is always Microsoft Excel, due to its ease of use and ease of access for everyone.

Create Cool Dashboards in Just 3 Steps

• In next three slides you will see how a Lame Dashboard is look like, how a Cool Dashboard is look like and how you can create a cool Dashboard with Microsoft Excel.

Sample Data For Creating Dashboard

• Just to let you understand a sample data is taken for 7 different regions with 2 years of sales figure. The data have 4 different columns column 1 is representing Region, column 2 representing first year, column 3 second year, and 4th column is representing Growth Percentage.

Example of A Lame Dashboard

That’s How A Cool Dashboard is

Formula To Use

Type the following formula in cell F5 and drag it to apply to all cells.

Use Conditional Formatting To Make Your Dashboard Colorful.

Thank You!For More Information and Help

About Microsoft ExcelVisit: www.ExcelAdvise.com