Today is a school holiday for kids. So we (Jo & I) are taking them to zoo for a day of walking, picnic and family time. Before I rush, I want to share a quick announcement with you.
KPI contest winners:
Thanks for everyone who participated in our recent KPI data visualization contest. Each and everyone who made the final list is a winner in my book. You have creativity, passion and a sense of sharing.
After reviewing all the entries and considering our judge’s opinions, here are the winners:
Winners of $ 100 Amazon gift card:
- George Gourgoulias – View original entry, Download workbook
- Reynaldo Peña – View original entry, Download workbook
Bonus prize winners (Print or kindle version of Dashboards for Excel):
- Ata Biabani – original entry, workbook
- Joon Tan – original entry, workbook
Congratulations to the winners. I have already emailed with the details on how to get your prizes. 🙂
Okay, I am off to see some elephants, tigers and birds now. Talk to you next week.
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.