Spreadsheet modeling or scenario modeling is one of the common uses of Microsoft Excel. People, especially in financial sector use MS Excel to do a lot of modeling. While excel has such powerful features like goal seek and scenarios, it also has a very useful feature called “cell styles” that you can exploit to make your spreadsheet models more user friendly.
Here is a small screencast to get you started. Excel 2007 comes with some great styles to mark various types of cells in the model, viz, input, output, calculation, warning, explanation etc.
What is your experience with cell styles?
I think they are easy to use and add consistent (and professional) look to the workbooks. What do you think?
Browse more quick tips and learn something fun before you take a sip.
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.