Ah, you thought I will let you go to the next decade without a “year in review” post? No so fast my friend, not so fast.
[This post is a bit long by our standards, but full of gooey excel goodness. So get a cup of coffee or choco and get going]
January 2009
The year 2009 has been pivotal in PHD’s life. It all started with a friendly email from Microsoft on Jan 1st telling me that PHD become an MVP. I felt wonderful knowing that. Even though the award meant little in terms of benefits, it is a great tribute to our little community and the passion we share here.
Later in the first week we wrote a post on how to make combination charts in excel. The discussion on combo charts continued throughout the year, so much that when I posted a holiday greeting card at the end of the year, Santhosh, one of our regulars said that they card looked like a combo chart.
Most importantly we have crossed the milestone of 2000 RSS subscribers in the Jan 2009. To celebrate that I posted one hundred excel tips. That was fun (plus Jo hated me for sitting in front of computer that long).
February
February is fun. I started off the month with an excel twitter client. Which became a wild hit on internet (ok, not so wild, but few of the other blogs in excel community did mention it. Also, JP, the rockstar VBA blogger at codeforoutlookandexcel made an add-in out of it)
Later in the month I got too excited to discover that you can use excel data filters to make a dynamic chart. By far the cheapest and easiest way to make a dynamic chart. We continued the discussion on dynamic charts for the rest of the year and posted several ways to make them.
March
I celebrated the one year anniversary of “conditional formatting rockstar” post by writing 5 more posts on excel conditional formatting. The series started with conditional formatting basics and went on to talk about how you can solve 4 most common problems using excel CF.
We also started writing about excel array formulas and continued that discussion off and on. Array formulas area fun and easy to write (once you have the basics right).
April
This has been a dull month what with my transfer from India to Sweden and sudden lack of internet connectivity. Despite all that we wrapped our first visualization contest on budget vs actual charts and posted some really excellent charting alternatives to the familiar problem.
PHD is also featured on Lifehacker for the Excel Formulas Errors – How to handle them? post.
May
We have proposed “Tweetboards” as an alternative to traditional dashboards and generated good bit of discussion in May. Later several readers emailed me their tweetboard implementations. Slowly tweetboards are spreading in the wild 😉
We also rounded up all the Excel 2007 Productivity Tips.
June
I have stared the Project Management using Excel series in this month with Project Management Gantt Charts. The 6+1 posts soon became legendary and helped me launch the project management templates. In total these posts had more than 200 comments, 150k page views in a short time.
June also was the best month PHD’s history as the blog got featured again on Lifehacker and Delicious home pages for the Excel Mouse Tricks post. Later that month we have rounded up all the techniques you can use to convert excel files to pdfs.
July
We focused on charting more and had the 14 skills you must have for making better charts. I have also written about the all too familiar sumif with multiple criteria problem and some formula solutions for it.
Later that month my post on Using Excel Goal Seek and Finding how much you need for retirement got mentioned in Lifehacker and fetched me a ton of new visitors.
August
Thanks to Aaron, who guest posted about excel waterfall charts in August. In august, I have turned my attention towards the pivot tables and wrote Excel Pivot Tables Tutorial. I have been playing with pivots off and on for a while and this post was my first serious attempt to explore the features. Later I wrote more about them and I am planning to explore pivot tables further in 2010.
In august, we have also crossed the 5000 RSS subscriber mark and celebrated it with a huge contest. Later that month I have wrapped up all the contest entries in the Excel Formulas – 29 tips post.
September
I have started the month with a discussion on Pareto Charts and how to make them in excel. Later that month I wrote about Excel Data Tables features. Both of these posts attracted a lot of discussion and helped me learn valuable new tricks in excel.
Later that month, on September 24th, I became a dad. My life has been the most wonderful and beautiful ever since.
October
In October we wrapped up the project management series with a Project Status Dashboards using Excel. Later that month I have launched the project management templates for excel product. I met several new customers and started to believe that I can make a living out of this blog.
November
In November, we started our most ambitious visualization challenge ever with the Zoho Sales Data Visualization challenge. We now have more than 30 excellent entries and I am waiting for Jan4th when we announce the voting for winner.
Also I have posted about the sumproduct formula and reviewed excel 2010.
December
We started the month with a discussion on using drawing shapes along with charts to make better dashboards. Later in the month I have written about making a quick thermo-meter chart and posted alternatives to compare targets using charts.
Finally I have released the free 2010 calendar excel for you to download and print copies.
To wrap up,
I liked this year thoroughly. Personally it has been nothing short of an exciting ride. We became parents, Jo got promoted, we purchased small piece of land (where we are going to build our dream house) and things couldn’t be better.
Blogwise, the year is equally exciting. I am extremely thankful to all of you for being there for me and encouraging me to learn and share. I met several new people thru this medium and made new friends.
I hope the year had been a memorable experience for you as well.
I sincerely wish you a prosperous new year 2010. Thank you.
PS: Those of you who visited the site yesterday must have seen the nagging “Database error”. I am sorry, but there was a problem when I moved the blog to a different server and the DB went down for almost 24 hours. Now it is up and running smoothly. Let me know if you see something funny.
28 Responses to “2010 Calendar – Excel Template [Downloads]”
[...] Download and print the calendars today. You can add notes to individual dates or complete … [...] Uni Ego / Free 2010 Calendar – Download and Print Year 2010 Calendar today [...]
Any chance on a 2016 calendar?
Afternoon,
I have one similar calander that I added conditional formatting to so that I could highlight any planned factory holidays. I think i "borrowed" the formula from another calander so I won't post it here.
I also added week numbers to it using the formula =WEEKNUM(MAX(C6:I6)) Where C6:I6 is the range of dates in that give week. It works fine on most of the months but return strange values on other months (Week 6 in October?) I can't see any logic behind why it does this.
Any suggestions for an alternative formula to give the week numbers?
Regards,
William
Hi Chandoo,
I've added a new feature on your spreadsheet.
This control can be useful for all the sheets where you need to check dates.
Cheers
http://cid-69a78592a23a8438.skydrive.live.com/self.aspx/.Public/2010-calendar%5E_Miguel.xls
Hi Chandoo,
Nice calendar.
Till now whichever calendar I saw in Excel, it contained only the outline sheet.
Good to see monthly views and the mini view too.
Liked the mini view much. 🙂
-Nimesh
@William: This weeknum may be because the input dates to max are not properly formatting as excel dates.
Good tip on the conditional formatting and holidays btw...
@Migueal: Now that is super awesome. This is the reason why I love to blog. Readers will always one up me with such cool alternatives. Thank you for sharing this with us.
@Nimesh: You are welcome 🙂
is it possible to get the Notes section on the outline page to display the notes added to the month page for a specific date?
So if you add thing for January 2nd, and then select January 2nd those notes appear on the outline page
@Shish... You can do that using some formula magic. I would not recommend pushing excel to that as outlook / google calendar / icalc etc. do exactly that much more elegantly.
[...] Perpetual Excel Calendar – Free Downloadable Template [...]
Happy christmas to all of you!
This is really awesome. The nicest calender I've seen for Excel. I also like Miguels version of the sheet.
Just one "feature" is missing to me. As I live in Germany - where weeks start on Monday - I'd like to change this. Could someone please give me a hint how to do this?
Thanks in advance
Jörg
Hi Chandoo, I’ve added some new features on your spreadsheet with your permission.
Check it here:
http://cid-6b219f16da7128e3.skydrive.live.com/self.aspx/.Public/Calendar%5E_Pedro.xlsm
Miguel, this calendar is translated to Spanish language.
Jörg, this new approach allows us to start weeks on Monday.
Also it's possible to start weeks on Sunday if you enable Excel macros and push the arrows.
Best Regards,
Pedro.
@Pedro.. superb stuff.. thanks for sharing the file with all of us.
Hi Chandoo, for dates before March 1, 1900 our calendars are wrong.
In Microsoft Excel, DATE, EOMONTH, WEEKDAY functions return an incorrect result between Monday, January 1, 1900 and Wednesday, February 28, 1900.
See this page: http://support.microsoft.com/kb/214326/en-us/
Microsoft Excel incorrectly assumes that the year 1900 is a leap year in all Excel versions.
That's the reason why our calendar versions only work from March, 1, 1900 until December, 31, 9999.
Your comments are welcome.
Pedro.
@Pedro.. Thanks for pointing that out. wow... This reminds me of the Joel Spolsky's first BillG review - http://www.joelonsoftware.com/items/2006/06/16.html (read it, I am sure you would love it.) when Bill out of blue asks about date time implementations for VBA (which Joel is the program manager for...)
Thanks for sharing the URL too... Here is a specially made, chocolate sprinkled, extra fluffy donut for you 🙂
Hi Chandoo, thanks a lot for the donut but I prefer it without chocolate!
Always it's good to know a little history of Excel.
The Joel Spolsky’s last BillG Excel review was about the "Hall of Tortured Souls"
(See this Excel 95 Easter Egg here: http://www.eeggs.com/items/719.html)
Do not miss the humor!
@Chandoo.. I just return with a new calendar version.
http://cid-6b219f16da7128e3.skydrive.live.com/self.aspx/.Public/calendar-pedrowave.xltx
It helped me to practice conditional formatting, formulas to show check boxes, data validation drop down list, find out Thanksgiving Day's date for any year, how to find dates of public holidays using Excel, all reading your wonderful posts!
Perpetual Calendar Spanish version starting weeks on Monday:
http://cid-6b219f16da7128e3.skydrive.live.com/self.aspx/.Public/calendario-pedrowave.xltx
Main characteristics:
- Not macros.
- Select a year from 1900 to 9999 with a dropdown listbox.
- All date fields with the real date format.
- Easy language change of day of the week and month names because are also dates.
- Hide Saturdays and/or Sundays.
- Week starting on Sunday or Monday.
- Week and month numbers.
- Hyperlink between sheets.
- Consistent colors to Holidays, Diary and Events dates.
- Easy change of Holidays by country.
- Include 80 World Days and you can add more.
- A diary with my birthday and 50 more programable appointments.
- Check box to hide individual dates or all.
- Holidays, diary and events text are showed on each month's sheet.
- Ranges defined with Name Manager variables.
I'll appreciate if you make me some suggestions to improve this calendar.
Pedro.
Please, I need help!
I like all calendar from Pedro, thank you for them. Let me show my problem:
I have 2 excel cells (for example AE12 and AE13) which mean the starting and the ending date of my duty. I need a macro to insert sheets with label YEAR. MONTH (for example 2010. August or similar) with the proper datas between the two dates. Is it possible?
Thank you for reading me and sorry about my terribel english! 🙂
Hello Pedro,
Thanks so much for the modified calendar template. I love the extra functionality you added. Is there any way you could upload an unlocked version? I wanted to change some of the comments and data validation so I could use it for one of my applications.
As for feedback on potential improvements, with all the additions you made the file runs pretty slow. I'm sure this has to do with all the interconnectivity between the various tabs, but if there is a way to use less memory via more efficient formulas or something else I think this would make it easier to use. I have a brand new computer and with it running alone the response was pretty slow. One of the changes I'm making is changing the order of the months to match my company's fiscal year, so maybe something to automate a change like that could be useful.
Cheers,
Peter
Peter, my calendars are unlocked but you need Excel 2007 and 2010 versions to open them.
Now I return with a new Programmable Task Calendar:
http://cid-6b219f16da7128e3.office.live.com/view.aspx/.Public/Calendario%20de%20Tareas.xlsx
Wath an introductory video here:
http://pedrowave.blogspot.com/2010/10/programmable-task-calendar.html
This new calendar allows to select the start month to match the school and fiscal year.
This is great stuff Chandoo and company
Wanted to know if someone had built something similar
I need to store one Excel Sheet on this calendar that has all the holidays
US Holidays appear in RED
UK Holidays appear in Blue
Meetings appear in Green
Submissions appear in Orange
Is there a way I can store the list in a separate worksheet and all the calendars get updated with this?
Thanks
[...] Calendars: Year 2010 Excel Calendar | Year 2009 Excel [...]
please tell me "how to convert Rs.10000/- in to words through excel formula
[...] is all! http://chandoo.org/wp/2009/12/11/2010-calendar-excel-template-downloads/ See more Templates at http://www.vertex42.com/ Share this:Like this:LikeBe the first to like this [...]
Greetings,
Thanks for this wonderful excel vacation tracker. I notice that the tracker only has three months November, December and January 2015, however, I would like to add the other ten months for 2014. Can you please instruct me on how I can add the other months?
Thanking you in advance.
Hi Chandoo,
Calendar: can this be printed as single sheet 8.5x11 inch per month
kanu
@Kanu
Yes,
You can resize it to fit
WOW! I just searching some of like this, that help me.
Thank you for sharing.