Hello Data Junkies & Chart Lovers,
I have a fun announcement for you. If you like to analyze data and present results in charts, then you can win up to $3000 in prizes by participating in Microsoft’s BI DataMashUp Contest. The contest is on from September 8th and runs until 28th.
How to Participate in this contest?
- Head over to DataMashUp Facebook App
- Follow the instructions to download PowerPivot CTP3 & Data sets
- Analyze and present results using Excel
- Upload your visualization screenshots to their site
- And if you won, you could walk away with $3000 or $1500 or $500 worth prizes.
Guess who is judging this contest?
You are right. I am going to judge this contest, along with few other industry experts & Microsoft employees. I am eager to see what you can come up with and learn from your techniques. So go ahead and participate. Visit DataMashUp page for details.
Special thanks to Romain & BI Team at Microsoft:
Thanks to Romain, Emilie from Microsoft who invited me to judge this contest. 🙂
More info & Tutorials on PowerPivot:
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.