SubscribeA New Year Resolutions Template that Kicks Ass
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.
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
- Free 2010 Calendar – Download and Print today
- Excel To Do List Application
- Use google docs to keep track of your new year goals
Trackbacks & Pingbacks
- Pingback by Annual Goals Tracker Sheet [awesome ways to use excel] | Pointy Haired Dilbert: Learn Excel Online - Chandoo.org on March 1, 2010 @ 9:58 am
Comments
RSS feed for comments on this post. TrackBack URI
Leave a comment
If you have a question, please ask in the forums
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. 
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.
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!
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?
@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/
Awesome, Jennie. Thanks a bunch.
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.
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
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.
Beautiful Jennie!! Very useful… thanks a million!!
@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
@Winston: Now that calls for some VBA magic… JP where art thou?
Thanks Jennie
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?
Hi, just discovered your awesome blog. Very helpful. Subscribed.
Thanks a lot and special thanks to Jennie…saved me some time from creating my own spreadsheet format ;P