[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.
Have you heard regarding Excel Dashboard Course ? I have talked about this many times. Actually i started creating this course over an year ago.
First time when i launched this course and till today it attracted over 1300+ students and which become one of my most successful course out there.
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
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.
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.
Features of this template:
This template allows to save the your daily task and display it in an interactive way. Many things to learn. This template makes it handy to display all the tasks in a form of calendar and combined with formulas and VBA one can make it even better.