Category Archives for "Excel Dashboards"

Compare growth rate with this template

[FREE] Excel Dashboard Growth Rate Template.

Use this template to compare growth rate for -
1. [For Good Growth Rate Indicators] Current YTD with Prior Year(Last Year)
2. [For Good Growth Rate Indicators] Current YTD with Targeted for Current Year
3. [For Bad Growth Rate Indicators] Current YTD with Prior Year
4. [For Bad Growth Rate Indicators] Current YTD with Targeted for Current Year

Normally, This template is available only for Excel Dashboard Course Subscribers but today for you it's FREE. Download it right away.

‚Äč

Excel Dashboard Mock up an Alternative solution

In the last blog post i have discussed that why mock ups for the dashboard are important and how to create one using an online tool.

There is also an alternative ways to create mock ups for your first Excel Dashboard. I would suggest to create these mockups for all the big dashboards you are planning to create. Let us discuss some alternative ways through which you can create mockups 

Create a Mock up for your first Excel Dashboard

If you are serious on creating a professional dashboard for your business then it's utmost important to introduce you with a technique which helps to create professional Dashboards.

The technique is mostly used to create a mock up of a website or an App(Android or IOS App) so i started brainstorming that how can i use this technique in creating professional Excel Dashboards. So here comes an in depth tutorial on how to create amazing mock ups for your first Excel Dashboard. 

Easiest Way to create Funnel Chart !

Funnel Chart is one of the type of data visualization chart which helps to analyse data. Funnel chart can be used for sales data reporting or Departmental profits reporting (like i have done in this demo). The most important thing which is needed is that the data should be arranged in descending order i.e from Higher value to the lower value (check out the image below). This funnel chart which we are creating is a inside the cell. We don't have to insert any chart its just created by conditional formatting and formula.