Here is a best practice to improve your dashboard usability. If you have an interactive dashboard, highlight user selections thru conditional formatting.
Check out below quick video to understand what this means.
You may watch this video on our YouTube channel too.
Download Example workbook
Please click here to download the example workbook for this video. Play with conditional formatting rules to learn more.
More ways to create awesome dashboards
- Never use simple numbers in your dashboards
- Place all vital information in golden triangles
- Show alerts & warning icons in dashboards with conditional formatting
- Create duplicate controls to improve usability of dashboards
- Add text narrative to your dashboards – case study
- Use shapes to enhance dashboards & charts
- Process & explanation – how to create awesome dashboards – podcast
3 Responses to “How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial”
Hi Chandoo,
I am responsible for tracking when church reports are submitted on time or not and the variations from the due date for submission.
Here is the Scenario;
The due date for the submission of monthly reports is on the 5th of each month. and I would like to know how many reports have been submitted on time (i.e, those that have been submitted on or before the due date) I would also want to track those reports that have been submitted after the due date has passed.
How can I create such a tracker?
Hi Chandoo,
I am a member of your excel school.
I was trying to create SOP Tracker I follow all your steps but I keep this error below.
The list source must be a delimited list, or a reference to a single row or cell.
I try looking on YouTube for answer but no luck.
can you help on this?
thanks
Carl.
Dear Mr. Chando,
Rakesh, I'm working in a private company in the UAE. Recently, I'm struggling to get more details about the staff sick, annual, unpaid, and leaves. I would like to get a tracker in excel. Could you please help me in this situation?
I also watching your videos in YouTube. i hope you can help me on this situation.