Best of Chandoo.org – 2011

Posted on December 30th, 2011 in blogging - 9 comments

Best of Chandoo.org in 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.

 

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

9 Responses to “Best of Chandoo.org – 2011”

  1. SARAN KUMAR says:

    @chandoo

    Fantastic job for 2011 and I wish you very all the best for the forthcoming years.

    I know you—-

    =IF(CHAR(53)*TYPE(CHAR(REPT(TYPE(” “),10)))/ROW()=COLUMN()*HOUR(NOW())+MINUTE(HOUR(NOW())),CHAR(TYPE(NA())*LEN(TYPE(NA()))),CONCATENATE(CHAR(182),CHAR(82)&UPPER(LOWER(MID(“CHANDOO.ORG”,7,1))),CHAR(67),CHAR(CONCATENATE(7,5))&CHAR(“8″&”3″),REPT(CHAR(LEN(“HAPPY NEW YEAR”)),TYPE(CHAR(” “))/2)))

    The above formula is for you

    Regards,
    Saran
    lostinexcel.blogspot.com

  2. Ashwin says:

    Hi Chandoo,

    Congrats and well done. Wishing you more success in 2012.

    Regards,
    Ashwin

  3. SARAN KUMAR says:

    why some part missed in my above comment formula….

    This is the whole formuala…chandoo is —-

    =IF(CHAR(53)*TYPE(CHAR(REPT(TYPE(” “),10)))/ROW()=COLUMN()*HOUR(NOW())+MINUTE(HOUR(NOW())),CHAR(TYPE(NA())*LEN(TYPE(NA()))),CONCATENATE(CHAR(182),CHAR(82)&UPPER(LOWER(MID(“CHANDOO.ORG”,7,1))),CHAR(67),CHAR(CONCATENATE(7,5))&CHAR(“8″&”3″),REPT(CHAR(LEN(“HAPPY NEW YEAR”)),TYPE(CHAR(” “))/2)))

    Regards,
    Saran
    lostinexcel.blogspot.com

  4. Debs says:

    Couple of most helpful emails from you were Excel Formula Help and of course the Christmas List. Thanks for everything you do and the good humor that comes along with it. Hope you all have a happy 2012!

  5. Fred says:

    Congrats Chandoo! I really enjoyed the Excel homework part. It is more interesting to try by hand and may be I will succeed or fail miserably. But the process was always stimulating to the brain.

  6. Richard says:

    This is my favorite post of the year! It pulls some of the most important stuff together in one place and it gives me a way of catching up on anything I missed without having to spend lots of time searching through the site. Kudos. This is fantastic.

  7. gopu says:

    Thank you for your all helps through chandoo.org
    and best wishes 4 coming year

  8. Darshana Mrug says:

    Dear Sir
    Went through Website . Sir , i have already burnt my pocket with an course of Advance Excel . no much use as i am not form programming background no C+ , No Vb … . Can excel really help with out VB base to create formulas like example Costing of a variety of Table , Items involved in making the table are :- Wooden plank , drawers , leg . every table is dynamic . If Table 1is to be assembled :- Plank + 2 drawers & 2 Leg . If Table 2 is to assembled :- Plank +1 drawer +4leg.
    I want to learn to create a complete costing & assembly sheets with excel I am placed at Mumbai.

  9. Luke M says:

    @Darsahana
    Sounds like your problem could be solved using SUMPRODUCT. Assuming you’ve got a header row with prices for each type of item (drawer,plank,leg) and then another row with quantities needed. Total cost then is:
    =SUMPRODUCT(RowWithCosts, RowWithQty)

    I’d encourage you to check out the forums for more help/ideas with Excel stuff. =)
    http://chandoo.org/forums/

Leave a Reply