Best of Chandoo.org – 2010
This year has been hectic for Chandoo.org. We have posted 229 excel tips & articles this year. In addition, we had 6500+ comments & a lot of new pages on the website. We have also trained more than 700 students in Excel & Financial Modeling thru Excel School & Financial Modeling School programs.
In this post, I will share some of the best content on Chandoo.org in year 2010. Just read these posts to supercharge your excel skills.
People & Websites that helped me in 2010 – A Big, Heartfelt Thank You
2010 has been phenomenally awesome for Chandoo.org.
Obviously, most of this success is due to the fantastic community here. That is you.
I feel really fortunate to have you in our community. You constantly inspire and motivate me to learn and share new things. Thank you very much.
But, apart from the vibrant community here at chandoo.org, I am also thankful to several others. I would like to remember all the kind souls who helped me through-out this year to make more of you awesome in Excel.
11 Excel Trackers & Templates to help you Rock 2011
We are just a few days away from 2011. New year always brings hope, cheer, joy and revitalizes us. So naturally many of us embark on journeys with new goals, resolutions, things to do.
Naturally, Excel can help us better manage the new year. In this post, I am featuring 11 templates so that you can have a rocking 2011.
Merry Christmas & Happy New Year 2011
Christmas & New year have a special place in our hearts. Around our household, we have the official festive season from September last week to February 2nd week. In these 5 odd months, we celebrate all our birthdays, our marriage anniversary, a lot of fun festivals, not to mention Christmas & New Year. This year, it is even more special because we have 2 noisy, hilarious & rowdy kids to share and multiply our joy.
We wish you a Merry Christmas & Happy New Year.
I also want to tell you that how much thankful I am to you. Without you, I wouldn’t be spending this holiday season with my family. Because you find me useful, and support me thru your visits, purchases, comments & enthusiasm to learn that I have the courage to leave my day job to embark on this exciting journey called chandoo.org. Thank you.
Use Filter By Selected Cell’s Value to save time [Quick Tips]
We are busy decorating the Christmas tree, making preparations for the holidays. But I have a very quick tip for you.
[Note: all these tips work in Excel 2007 or above]
Whenever you are working with huge lists of data, filtering & sorting is one simple way to analyze the data quickly.
You can quickly filter your data based on current cell’s value by right clicking and then selecting filter > filter by selected cell’s value.
How would you Visualize World Education Ranking Data [Homework + Video]
Here is a charting challenge to begin your Christmas week. Recently Guardian’s Data Blog released World Education Rankings data and a sample visualization. Now your challenge is to make your chart visualizing World Education Rankings data.
You can see the chart I have constructed above. Read the rest of the post to find out how I made this chart and download the workbook.
Post your submissions using comments.
2011 Calendar – Excel Template [Downloads]
Here is a 2011 new year gift to all our readers – a free 2011 calendar template.
(a little secret: just change the year in worksheet “Full” from 2011 to 2012 to get the next year’s calendar. It works all the way up to year 9999)
You can add notes to individual dates or complete month using the excel template very easily. There are 6 different calendar templates in the download file,
* 4 Yearly Calendar Templates with different color schemes.
* 1 Mini Calendar
* 1 Monthly Calendar (prints in 12 pages)
Go ahead and download the calendar files. Enjoy.