A Challenge from Hui

Hi All.

I am about to head off on holidays for a couple of weeks during which time I will only have limited internet access and won’t be helping out here at Chandoo.org or at the ExcelHero Academy whilst away.

I thought I may leave a few words and a Challenge for everyone.

History

Hui - Our Excel NinjaIn mid 2009 when Chandoo setup the forums I was an infrequent visitor to Chandoo.org. Chandoo had a neat way of writing his posts, not dissimilar to how I write which is personable and not text book style.

The first time I saw the forums there was about 20 unanswered posts, which I decided to see if I could tackle. When the forums were setup we used to get about 2 posts a week (on a busy week) and sometimes a week would go by with no posts.

Although I’ve used Excel for ages, I didn’t consider myself an expert by any measure. There were areas where I was very competent (Sumproduct & Data Tables) and I do consider myself very good at systems analysis, but I was no way an excel expert.

However I was surprised at my ability to answer most of the questions posted, and so would set myself a challenge to research and try and solve the posts that I couldn’t directly answer.

I will admit to being nervous when posting my first few responses.

– What if I make a fool of myself?

– What if the answer is wrong?

– What if my answers aren’t . . .

You get the idea.

What I found was exactly the opposite.

Most of my answers were close, and people would tell me when they weren’t right and we’d work on the problems together, even if it meant 40+ posts to solve an individual question.

People started appreciating the efforts I was providing and saying Thanks.

I realized that a lot of the problems weren’t actually Excel related, but more were data organization, data flow, problem analysis related, and I fitted into that slot easily.

Chandoo all of a sudden made me an Excel Ninja, which apart from the Free Gold plated Ninja Sword, Free Black Hood and Magical Powers, gave me the power to Edit my own posts and Delete others when they were rude/obnoxious etc.

But most of all I found my own Excel skills were developing quite rapidly and mostly into the areas I wasn’t familiar with.

This came about from not just answering the questions, but from the research into some of the harder ones. The research often took me to sites and into techniques and areas that I’d never seen or heard of and I was able to apply these to unanswered questions and work. I recently stumbled across a web page and was able to answer a post question which was 20 months old with what I had found.

Obviously since then I have written about 30 posts for Chandoo.org and have been allowed to run the site whilst Chandoo Holidays teaches Excel around the world.

Thank you

So firstly a thanks to Chandoo for giving me the opportunity and authority to post without censorship or review and to take care of his site from time to time, I’ve really enjoyed all of it.

I also want to thank the other users who regularly answer Forums posts, including our second Ninja Luke M as well as Vijay Sharma, Dan_L & Fred and all the others who answer posts, for assisting me in recent times.

 

YOUR TWO CHALLENGES

Challenge 1. Answer a Forum Post

To assist you in developing your excel skills, I won’t be answering any posts whilst on holidays, mostly because I will have limited internet access and won’t have access to Excel. Also when I get back from holidays, I’m going to stop answering Forum Posts until they are unanswered for 2 days.

My Challenge is for you to step in and fill the void.

Take the first step and try your hand at answering a few Forum posts.

Don’t be shy or ashamed of making a mistake. Your mistake will get picked and corrected and you and then many others will learn from it as well.

Start with simple posts you know or sort of know.

Give yourself a goal of say answering 1 post per week, or answering the next question on a specific topic. Read other answers and if they aren’t quite right or you can add to the story, do so, in a polite way of course.

Write as you would like people to speak to you.

Please be aware that we get posts from all languages and often the Poster’s translation into English isn’t perfect. Be patient.

Visit our forums & chip in today.


Challenge 2. Write a Post

If you have any specialty areas/skills or excel techniques why not try your hand at penning a post.

If you have developed a neat Dashboard or Report or anything else Excel that your proud of, why not try and write it up as a post so that other can learn from your skills.

Send any draft posts to either Chandoo or Myself in any format (Word or just plain text)

So I’m off on Holidays.

Take care of the forums whilst I’m away and good luck with the above challenges.

Hui…

PS: Please don’t post or rush to answer posts marked as URGENT, etc, Direct people to the Posting Rules & Etiquette Page.

Added by Chandoo:

How can I thank Hui for all he does. He is a great teacher, friend & supporter of our work here. He shows immense passion for helping people and teaching what he knows. I feel so fortunate to have known him. Wish you a kickass holiday Hui.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

11 Responses

  1. Enjoy your holidays…Hui………..you are really a champ…………….the challange seems to be intresting….Although I havent helped much but have really learned a lot from following the forum…

  2. Have a great holiday and “Haste ye Back”.
    I’ll put my thinking cap on and try to answer at least one post while you’re gone
    Shalom
    Auto

  3. Hey Hui enjoy your holiday and you are right you are not an Excel expert, you’re an Excel legend! I am amazed by the solutions coming from you all the time to real world problems. I am also going to have a crack at the blog and my reluctance until now were exactly for the same reasons you mentioned.

  4. Hui – two whole weeks away from Excel, and you call that a holiday? Sounds more like you’re going to rehab 🙂

    Enjoy!

  5. hi chandoo,
    thanx for your templates and formula which help me a lot i am a management consultant because of your formulas know i can analyze and compare lots of data easily and give right solution to my customer.

  6. hey, great site, this is one of the best, do you sleep! No, really, you do add a lot to the community, thank you. Cool hair in the pic too.

    Not a spammer.

    Christopher

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.