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.