We Want Your Ideas – Results

Posted on July 22nd, 2011 in Huis , Posts by Hui - 8 comments

Two weeks ago we asked you what you wanted to see at Chandoo.org and you responded.

We have had 71 responses giving us 101 ideas to date.

Here are the results…

It is very clear that the respondents to the survey want to see more VBA, both at basic and advanced levels.

The other theme to emerge was that people are interested in Dashboards and the Integration of Excel into other Office applications and ERP/BI systems.

A few respondents also wanted more Competitions and Challenges. If your business would like to sponsor these please contact Chandoo.

A Number of posts are already planned covering some of your ideas.

As always this data can be presented as a simple dashboard.

 

Whats Next

A number of posts are already planned and well underway covering some of the ideas presented.

These will be published in due course.

 

What’s Already Available at Chandoo.org

A number of ideas requested in the above list are already covered to some extent at Chandoo.org or elsewhere and you are encouraged to visit these links

Advanced Statistics

http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/

http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/

http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/

Dashboards

http://chandoo.org/wp/excel-dashboards/

Data Tables

http://chandoo.org/wp/2009/09/10/data-tables/

or

http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/

Dynamic Charts

http://chandoo.org/wp/tag/dynamic-charts/

Index/Match

http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/

http://www.excelhero.com/blog/2011/03/the-imposing-index.html

LOESS Modelling

http://peltiertech.com/WordPress/loess-smoothing-in-excel/

Lookup

http://chandoo.org/wp/tag/vlookup-week/

Learn VBA

http://chandoo.org/wp/vba-classes/

 

Don’t Fret

If you contributed to the survey and don’t see your idea covered above, don’t fret, it may just pop up and surprise you one day!

 

Your Contribution

If you have expertise in any of the unmarked ideas and would like to try your hand at a guest post or two contact Chandoo or Hui.

 

Your email address is safe with us. Our policies

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

8 Responses to “We Want Your Ideas – Results”

  1. Rich says:

    Psst. Chandoo… While your link’s text for http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/ is correct, the actual link is missing the “/wp/ directory on the three forecasting articles ;)

  2. Fred says:

    Link on dynamic charts: http://chandoo.org/wp/tag/dynamic-charts/ is not working.

  3. Hui... says:

    @Rich & Fred, All links fixed. Thanx.

  4. Avadhut says:

    Hey Chandoo,

    That’s awesome way of managing the things..market oriented. Give them what *they* want.

    My best wishes

  5. Chris says:

    Hello,

    I view with interest that there is a strong request for More VBA.

    Understandably, the people who have been following this site for a long time have probably progressed to this level and VBA is of great interest.

    BUT, The valus of this site to me is that it shows people of all ecxperience types how to improve their skills, not only by geeky technical knowledge, but skills in visualisation, presentation and analystics – without the need to be a coder.

    You run a great risk of alienating new members who are not at this level when they view your site for the first time.

    I’ve mentioned this before, and I speak from my own experience having used this site since 2008.

    The problem with advanced skills is, if you leave your role you run the risk of all your work being redundant because the person taking over the role (or general business users) do not have the same technical knowledge to run and maintain the s/sheets as you have done.

    You also run the risk of widening the gap between the business and it’s data (and you), something which most analysts/ excel users work to avoid.

    Not to appear negative, perhaps the answer is to segment you site, or create a new and separate technical stream.

    And remember, just because something is done simlpy and basically (without VBA or macro’s), doesn’t mean it is not done well. This is the ethos That I gained from being a member of this great site.

    I have been an analyst for 12 years, across Retail Banking, Adverting/ Media and Government and the skills I have learnt here have assisted me greatly in not only achieving this, but loving the work that I do.

    Please don’t lose sight of the orginal aim of the site.

    Having created dashboards, models, achieved forecasting goals etc, I now class myself above most of my peers in visualisation and analysis of data as a result of this site. Without ever using VBA.

    Many Thanks

    Christian

  6. Stephen says:

    Just wanderful to be asked what we wanted to see, thank you.
    But being me, I wouldn’t let it lie. There are a number of items that could be consolidated above: e.g. cloud computing, web stuff, and web/cloud excel…. then there is less of a list of work.

    I have plagiarised some notes (for people at work) on INDEX, INDIRECT and fuzzy LOOKUP if you would like me to write an artical on any of them? I also have some skill with large data analysis and Google Spreadsheets but suggest that you contact a guy called ahab for any articles on Google!

  7. […] This functionality was also one of the more requested issues from our poll of 3 months ago We Want Your Ideas! […]

  8. Linda Ely says:

    I have been tasked with teaching Excel and Access to the very beginning beginners; I was told today (23 Aug 2013) and start Monday ( (26 Aug 2013)! Wow! Any help would be appreciated! I know I use your site for things that I have problems with, but I know (or I think I know) that they will not have the same problems. This is going to drive me crazy until I actually can sit down with the students and figure out what they know and what they don’t, so I have a starting place and can plan an ending place with a well-defined “road” to “travel” between the two points! Thanks for listening…

Leave a Reply