A New Year Resolutions Template that Kicks Ass

Posted on January 7th, 2010 in Charts and Graphs , excel apps - 38 comments

Jennie, a sweet and ambitious lady set out to do 101 things in the next 1001 days. She took the inspiration from Day Zero Project. Not stopping there, she prepared a cute little excel sheet to keep track of all these new year resolutions and sent it to me.

I think this is a swell excel template if you want to keep track of your goals or new year resolutions or just manage a list. See it for yourself.

New year resolutions - template - download today

The file uses lots of excel goodness like conditional formatting and excel check-boxes. As soon as you mark a goal (or resolution) as completed, it is highlighted in a different color.

Plus there is a thermo-meter chart too, to show the progress. Pretty cool eh?

Download the Excel New Year Resolution Template

Click here to download the template. Go and make some goals and achieve them. All the best :)

Thanks Jennie

Thank you so much for sharing this with us.

If you like this file say thanks to Jennie. Even though it is not one of her 101 goals, I am sure she likes to be thanked by a stranger across the world.

Related Templates and Downloads

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

38 Responses to “A New Year Resolutions Template that Kicks Ass”

  1. Loranga says:

    Thanks Jennie, and good luck with your goals. If you complete #26 maybee you can sell it to me? We had -34 degrees celsius here this morning.

  2. Dan D says:

    Great List! I made one small improvement. By making cell H3 read =MAX(B8:B108) I have been able to make a list as long (or short) as I like and the ‘thermometer’ updates accordingly.

    Thanks again for a great tool!

  3. Ubique72 says:

    Nice work Jennie – hope the weather improves because I certainly can’t do #26 anytime soon…

    Chandoo – a silly question – how do you format the sheet to show no grids etc – I notice that all your examples have a clean white sheet…I paint the background to white so not sure if you do something else?

  4. Chandoo says:

    @Dan D: good stuff.. :)

    @Ubique72: Try hide gridlines option from View > gridlines in Excel 2007 (or Tools > options > “view tab” > remove grid lines). See here for more on this http://chandoo.org/wp/2009/08/13/hide-grid-lines-quick-tip/

  5. Steve says:

    Awesome, Jennie. Thanks a bunch.

  6. Jen says:

    Thanks Dan D for that little fix. I have amended on mine for those don’t need a list of 101.

    I won’t be getting around to #26 for a few months as it is summer here and +30C.

  7. winston says:

    Awesome stuff!
    Thanks Jennie.

    Wouldn’t it be cool if we could modify to drag/drop from Outlook and automatically add a task from an e-mail item?

    No idea how to do that, but it would be cool!
    Thanks
    Winston

  8. Gregory says:

    I really like this worksheet, however there is one glaring problem. From 1/1/2010 to 9/28/2012 is 1002 days! I’m surprised that no one checked this

    The math for the difference between two numbers is B – A + 1. Or you can just start a series of dates in cell A1 starting with 1/1/2010 through 9/28/2012 and find the last date in row 1002.

    The check boxes linked to the graph and the conditional formatting for completed items is fantastic. Nice job of formatting.

  9. Michelle says:

    Beautiful Jennie!! Very useful… thanks a million!!

  10. Chandoo says:

    @Gregory.. thanks for pointing out the simple math mistake. one donut for that :)

    On a more lighter side, if you ever get to do all the 101 things you want to, I am sure you dont mind one extra day :D

    @Winston: Now that calls for some VBA magic… JP where art thou?

  11. Alex Hu says:

    Thanks Jennie :D

  12. Branden says:

    Jennie your spreadsheet is easy to use and very nice to look at, great job!

    I am working on a project that could use this technique, however I’m having an issue copying the checkboxes down each row. All the links point to the original checkbox’s cell. Can anyone help, or do I have to manually change each box?

  13. Rishi says:

    Hi, just discovered your awesome blog. Very helpful. Subscribed.

  14. fazal says:

    Thanks a lot and special thanks to Jennie…saved me some time from creating my own spreadsheet format ;P

  15. […] the year. To keep track of these activities I took the liberty of modifying Jennie’s A New Year Resolutions Template that Kicks Ass and created a more “dynamic” […]

  16. Od says:

    I want to create a list of 25 action items instead of 101. How to i do that? I am a newbie, you would have figured that out anyway.

  17. Kimberly says:

    Hej! I LOVE this. The only problem I’ve encountered is being able to check the boxes. They work when the document is read-only. When I “save as” so I can fill in the cells, I can no longer check the boxes. I suck at Excel..ha ha! I thought it could be that I use Ubuntu with Open Office, yet I would think I would have a problem in read only as well if it were that. Ideas?

  18. Kimberly says:

    I fixed myself…duh. Instead of “save as” I used “edit file” copy.

    Thanks for a great template!

  19. […] ????? ?? ?? ??. Thanks, […]

  20. Louise says:

    Jennie, brilliant list,
    id like to create something like this,
    how did you link the thermometer chart to the check boxes? if anyone can help?

  21. Ankita says:

    Nice template sir, thank you.

  22. Andrew says:

    Good News: Found a great template for making 2012 goals
    Bad News: Feeling like a complete sloth because there is no way I could so most of those already listed. :-|

  23. […] with other long term goals, Excel can make the magic happen. Fellow MVP Purna Duggirala posted an Excel spreadsheet template that takes advantage of conditional formatting and check-boxes to create a list of goals and track […]

  24. Pradeep says:

    Thanks Jen for the wonderful sheet. I think you are already on the road to become awesome.
     
    @Chandoo: I know a bit of excel but now learning awesomeness from your site and all I can say is thanks for being here.
    Can you please explain the making of this sheet for the beginners.

  25. rajinikanth says:

    Thanks Jennie…very useful stuff

  26. Christy says:

    Thanks Jennie! I have altered it so its 36 things to do in 365 days! I stole a few of your resolutions too, great list! Thanks!

  27. […] while ago, we published a new year resolution template. This was a hit with our reader with thousands of you downloading it. During last week, Peppe, one […]

  28. Karthik says:

    Hi All,
    Did anyone noticed that columns H, I’s formatting??
    whatever you type, just goes invisible, (once u out of the cell), but the value stays in the cell!!!
    Awesome custom format ;;;
    I love it! Let me play with my seniors @ office with this cool format trick :)

  29. Estee says:

    Hi Jenni,
    I’d like to make my own template with a gant chart as what you’d done but I’m very novice. Would you share your knowledge how to make it step by step? Thanks a million.

  30. Michael says:

    Thanks Jenny, it will come in handy in my new year’s resolution.

  31. Pratyusha says:

    I read Jenny’s article a year and a half ago… a little over 450 days to my 30th birthday. Inspired, I made my own list of 45 things to do in 450 days…the day I turn 30. I covered ~55% of the goals, and reading 45 books was one of the most time consuming, yet rewarding. I exercised more, took up pottery classes, tried new things and couldn’t have asked for a more rewarding experience. I dint get to watch 5 plays (got to 4) and swim once a week, for 50 weeks, volunteer for causes and spend ~60hrs (got to 20, but have enrolled in a program which is more sustained now, and hopefully a more longterm association), watch the husband play local football matches once a month… but then again, its a working list, and I loved the positivity it brought to me.

    Thanks So Much Jenny! I hope you got to do most of the stuff on your list too.

    This birthday, I’ve made a list of 30 things I want to do over the year. Cant wait!

  32. […] , I stumbled upon this really cute list made by one JENNIE from New Zealand. You can find it here. She’d listed 101 things she planned to do in 1001 […]

Leave a Reply