Using a great task analysis tool–Excel Sheet

by Ashvini on January 17, 2013 · 4 comments

in My Personal Thoughts

When you are an entrepreneur, the most important frame of mind that you need is problem solving.

Entrepreneur fights his/her way through a multiple number of issues every week , be it financial, sales or anything else under the sun. Problem solving mind-set can work to entrepreneur’s advantage.

The most important thing is not to get overwhelmed but work on one thing at a time. Break down bigger tasks into smaller ones, prioritize and make a list. Use Excel for doing this. You don’t really need anything fancy.

Put these columns

  1. Task
  2. Date of writing the task
  3. Today
  4. Date of completion of the task
  5. Deadline if you prefer.
  6. Difference between date of completion(4) and writing the task(2)
  7. Difference between today and date of writing the task
  8. Priority( Low/medium/high)
  9. Remarks

Use a great excel sheet function called as TODAY() for column 4. It will give you the best way to measure how much time has gone by since you wrote down the task. That value will tell if you are really putting off the task too. If days go too far, complete that task first and then move on to something else. You can also find out on which priority you are falling behind. Then you can write in remarks why you took so long. Analyse and improve :).

Here, I gave you a small easy analytical tool.

About The Author


Christian January 18, 2013 at 9:45 am

Nice tips and I also know a couple more tools and way to stay focused and get things done but I they never, ever seem to work out for me. I tend to keep everything in my mind, maybe write it down on a piece of paper and the I lose the paper…but that’s another story.
Anyway some people (like me) work better in their own messy way, though I’m pretty sure we are rare…

Ashvini Kumar Saxena January 25, 2013 at 9:00 pm

Hi Christian,

Thanks for your comment. I am sure we have our own ways to be better organized. Would you mind sharing the tools that you are talking about for the benefit of our readers ?

Rana Sinha January 17, 2013 at 6:14 pm

Useful tips. This is a good and simple to use tool, thanks for sharing. I use simple paper for this purpose but using an Excel sheet leaves a document, which can be very useful for follow-ups.

Ashvini Kumar Saxena January 25, 2013 at 9:00 pm

Very true Rana and I have found excel to be very easy to use. We don’t have to learn new interface. Thanks for your comment :)

Comments on this entry are closed.

Previous post:

Next post: