Hello readers, I have an exciting announcement for you.
I will be presenting at two events at London in April 2020. Please consider this my personal invitation and join me for Excel + Power BI fun.
01 – Global Excel Summit 2020
London, 21-22 April 2020 (Tuesday & Wednesday)
I am thrilled and honored to be presenting at Global Excel Summit in London, coming April. I will be doing a full day session on advanced charting and one hour presentation on how I built a million dollar product running my online business.
You will be hearing from Excel / Power BI greats such as Bob Umlas, Boriana Petrova, Gasper Kamensek, Oz Du Soleil, Sumit Bansal, Leila Gharani and many others.
This is a must attend event if you live close by or need an excuse to visit London.
10% discount for Chandoo.org readers
Please use the promo code Chandoo-10% to get 10% discount on the global summit ticket price.
Click here to know more and book your spot.
02 – Excel + Power BI Masterclass
London – 23,24 April 2020 (Thursday & Friday)
If a large conference is not for you or you just can’t get enough of that Excel + Power BI goodness, then please consider my special Masterclass event. In this two event, you will learn,
- Day 1 – Advanced Dashboard Reporting with Excel
- Day 2 – Mastering Power BI, Power Query and Power Pivot
Each day is a standalone course, so you can sign up for either of them or both.
Early bird discount – sign up before end of year
If you sign up before end of this year (2019), you will get £50 off one day option or £75 off two day option.
Thank you and see you in London 🙂
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.