Tutorial 1: Building the simplest MS Excel dashboard
Are you tired of searching for that simple practical easy step-by-step solution on how to build an excel dashboard without wasting much time and without getting bored flipping through infinite information?
Then relax coz you have arrived at your ultimate destination.
If you want to build the most basic form of an Excel Dashboard from scratch, just go through the image below: For conceptual explanation Go through this presentation:
Our Simplest Dashboard has a single indicator which is a pie-chart tracking the % break-up of all expenses incurred till date. To create this database we follow 4 steps:
Step 1: Present the data in a “list format”
Step 2: Filter out the essential data from the list
Step 3: Create a metric by processing the filtered data
Step 4: Assign a visual indicator to the metric
Download the Excel file here. ( approx. USD $1.50 ) This file is not free and will have to be purchased at a nominal value. Helps me to keep this website afloat :)
This concept can be extended to create more complex forms of dashboards. They can also be very handy tools of precise analysis on a regular basis.