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.

Top 10 Posts written in 2010

1. Sales Dashboards – 32 Examples & Downloads 0.82% page views
   
2. Dynamic Dashboards in Excel – Part 1 0.52%
3. Pivot Table Tricks 0.36%
4. Learn Excel – 31 Tips & Tricks 0.35%
5. Delete Blank Rows in Excel – How to 0.31%
6. Comprehensive List of Excel Keyboard Shortcuts 0.28%
7. FIFA Worldcup – Round up of Excel spreadsheets to track scores & points 0.26%
8. Compare 2 Lists in Excel 0.22%
9. Dynamic Dashboards in Excel – Part 2 0.21%
10. Data Tables & Monte Carlo Simulations in Excel 0.21%

Most Read Articles on Chandoo.org in 2010

1. Chandoo.org – Blog home page 7.55% page views
   
2. Gantt Charts in Excel – Free Template & Tutorial 3.07%
3. Excel Templates & Downloads 2.57%
4. 73 Templates for better Charts 2.06%
5. Project Management Templates in Excel 2.00%
6. Pivot Table Tutorial 1.92%
7. Excel Dashboards – Templates, Tutorials & Examples 1.71%
8. Excel Formulas – Online Help 1.46%
9. Project Milestone Chart – Free Template & Tutorial 1.31%
10. Creating KPI Dashboards in Excel – Part 1 1.28%

Sites Sending Most Traffic to Chandoo.org

[Note: Out of total visits, roughly 10% are from external sites linking to us. Out of this 10%, the below referrers’ share is mentioned in %s]

1. Peltier Tech 2.56% visits
   
2. Enterprise Dashboard 2.48%
3. Coliss 2.27%
4. Clearly and Simply 1.68%
5. Cogniview 1.46%
6. Lifehacker 1.41%
7. Datapig Technologies 1.22%
8. Plum Solutions 0.87%
9. Contextures 0.80%
10. Sparklines for Excel 0.78%

Key Trends this year

In year 2010, the key themes for Chandoo.org were,

• Making more people awesome in Excel thru blog content, news letters & Excel School
• Having diverse content thru Guest posts (thanks to Hui, Paramdeep, Itay, Yogesh, Larry, Faheem, Daniel, Myles and many others who shared content / ideas with us)
• Sharing more ideas, implementations about Dashboards
• Engaging our readers more with homework, awesomeness week & polls
• Showcasing Excel 2010’s new features & uses
• Having fun all the while.

What content did you Enjoy in 2010?

Please share the articles, links you enjoyed most on Excel (or related topics) thru comments. I would love to know what excited and taught you most in 2010. Go ahead and share.

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.