Best of Chandoo.org – 2011

Best of Chandoo.org – 2011:

This year has been the most hectic since we started Chandoo.org. We had 178 posts, more than 7,500 comments & 10,000 forum posts. We have trained more than 2,500 students thru Excel school, VBA Classes & Financial Modeling Classes this year alone.
More than 3.5 million people visited our site this year, spending an average of 2:30 minutes per visit, consuming a whopping total of 10.5 million page views. Just to give you a comparison, last year (2010), we had 1.5 million people visiting 5.5 million pages. We have also added 17,000 more RSS / Newsletter members this year. It is a hectic year for the site.
To wrap up the wonderful year, I want to share a list of posts that most of you loved.

Top 10 posts written in 2011:

1. 220 MS Excel Tips & Resources for you 35,124 page views
2. Introduction to Excel Form Controls 22,268
3. Sales Analysis Charts in Excel – 78 Alternatives 20,156
4. 33 Resources for Making Excel Dashboards 16,748
5. Interactive Dashboards using Hyperlinks 16,489
6. Customer Service Dashboard in Excel 14,326
7. Analytical Charts in Excel – Tutorial & Download 14,169
8. Trend-lines & Forecasting in Excel [3 Part tutorial] 13,960
9. Updating Pivot Table Report Filters using Macros 13,666
10. KPI Dashboard in Excel – Revisited 12,563

Honorable Mentions:

1. Learn Any Area of Excel – 80 Links for you 12,045
2. Create PPT using Excel & VBA 11,060
3. Spreadsheets for Teachers 10,868

Most Read Articles on Chandoo.org in 2010

1. Chandoo.org Home Page 548,000 page views
2. Download Free Excel Templates 326,745
3. Excel Dashboards – Information, Templates & Resources 310,204
4. Excel Pivot Table Tutorial 237,003
5. Excel Gantt Chart Template 231,095
6. Excel Project Management – Information, Templates & Resources 159,703
7. 73 Ready to use Excel Chart Templates 151,181
8. Excel Formula Help 138,920
9. Project Milestone Timeline Chart 125,716
10. KPI Dashboards in Excel 112,683

Honorable Mentions:

1. Introduction to VLOOKUP, MATCH & OFFSET formulas 109,033
2. How to use Excel’s Paste Special? 98,304
3. Excel Quotation Template 89,202
4. Delete Blank Rows in Excel 86,756
5. Learn Excel Conditional Formatting 85,307

Key trends this year

This year, our key themes / trends are,

• Making more people awesome thru our blog, newsletter, Excel School & VBA classes
• Involving more guest authors – Hui, Paramdeep contributed a lot to the site
• Growing our forums – Now we have more than 3000 discussions answering several everyday Excel questions
• Engaging our readers thru polls, homework problems, challenges.
• Having fun all the while

What Posts did you enjoy most this year?

Please share your favorite articles, tips using comments. I would like to know what you like the most.