Excel Links – Happy Birthday Edition

Posted on October 20th, 2010 in excel links - 31 comments

First some personal matters.

Today I am celebrating my 28th birthday. The last one year has been very good for us. We have been very busy parenting 2 hilarious and naughty twins, I moved back to India, quit my job and started a company. My business became a mild success crossing $100k revenues in 12 months. I have started Excel School – online training program and met 690+ eager, enthusiastic and energetic students. We bought a car and I learned how to drive on Indian roads. Like my kids, this blog too had grown – we have 13000+ members (6000 last year this time) and we had 4.5 million views in last one year. Thanks to sweet readers like you.

Jo (my wife) wouldn’t be happy if I sit in front of computer all day. So I have compiled a list of excel links for you. Go ahead and enjoy these. Then, come back tomorrow for another juicy excel nugget.

Using Reference Lines & Trend Lines in Scatter Plots – Useful Theory

Visual Quest is one of my new favorite blogs. It is maintained by Paresh and he writes about interesting charting examples, visualization theory and practice. In this article, Paresh shows us how to use reference lines and trend lines in scatter plots. Read if you work with scatter plots often.

How to use OFFSET formula -tutorial

OFFSET formula is one of the most powerful and useful formulas in Excel. It is a must if you work with dashboards, reports or advanced excel models. In this article, Gregory from Excel Semi Pro explains how to use offset formula. (check out alternative explanation for OFFSET formula)

How to do a case sensitive lookup in Excel?

We all know that excel look formulas are case insensitive. That means =vlookup(“boy”,..) and =vlookup(“BOY”,..) find the same thing. Dick addresses this problem by sharing a formula that can do case sensitive lookups. Read it for interesting formula technique.

Peltier erects a bullet chart – tutorial

Finally it took a Peltier to erect a bullet chart. Jon Peltier shows how to create a vertical bullet chart in excel. Pretty interesting technique.

A simple trick to test for empty cells in Excel

It is common practice to test for empty cells while writing formulas. The usual formula is something like this, =IF(cell=””,0,cell). But this is too lengthy for a simple empty cell test. Mike at Data Pig website shows an interesting formula technique for doing the same.

Got an excel link? Please share:

If you want to share an excel tip or article with our readers, just drop a comment or write to me at chandoo.d @ gmail.com.

Read previously shared excel-links.

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

31 Responses to “Excel Links – Happy Birthday Edition”

  1. govi says:

    Congrats! Enjoy your birthday!

  2. Hui... says:

    Happy Birthday Chandoo
    I hope your next year exceeds your dreams and expectations

    Hui...

  3. Smitha goutam says:

    have a wonderful bday!!

  4. rajatha says:

    Happy Brithday Chandoo....

    Hope you have a better year ahead

    Love
    Rajatha

  5. Steve P says:

    Happy Birthday!! Your site is fantastic. I learn something new everyday and have now configured firefox to have your site as one of the startup tabs.

    Have a great one

  6. Ken Puls says:

    Happy Birthday, Chandoo. I hope that your next year is as prosperous as your last one!

  7. paresh says:

    Happy Birthday!!!!!

  8. Gregory says:

    Happy Birthday! I'd like to point out that you don't actually step into your 30's until you turn 30. Enjoy 29 while it lasts. Time flies when you're having fun.

  9. Ted says:

    Wow, I feel honored to share my birthday with such an Excel guru. I have learned many new things from your e-newsletter, since signing up a few months ago. Thanks for sharing your knowledge with the wanna-be gurus. Have a great birthday Chandoo and enjoy some time with your family.

  10. Francis Chin says:

    Happy Birthday Chandoo !!! You are so young !!! But so successful ! πŸ™‚

    Enjoy your sweet 28 ! πŸ™‚

  11. Vio says:

    Happy Birthday! Hope your birthday blossoms into lots of dreams come true!

  12. gaallen says:

    Have a great one! Thanks for all the assist you provide. Hope your biz doubles in size next year.

  13. TJ says:

    Happy Birthday Chandoo

  14. FJRR says:

    Congratulations and keep sharing with us your experiences.

  15. jill says:

    happy birthday!! πŸ™‚

  16. David Larsen says:

    Here is a link to an Excel utility that I simply could not do without: http://www.asap-utilities.com/
    This utility saves so much time (once you can remember the navigation scheme of the add-in).

    David

  17. Murugaraj says:

    Happy B'day, Chandoo!
    And Congratulations on your achievements last year. Sure you have already set better targets for the following year. May you always succeed and be happy.
    -Murugaraj

  18. Rohit jindal says:

    Happy Birthday Bro.

  19. Kalyan Chattopadhyay says:

    Wish you a very HAPPY BIRTHDAY to you

  20. Deepak Kumar says:

    wishing you a very-very happy b'day chandoo

  21. Unmesh says:

    Dear Chandoo,

    Happy Birthday !

    I came to know about your site this morning and really like to enroll for the basic Excel program. How can I do that?

    Also I noticed that you do not have direct payment gateway on your site. Would you be interested to have a merchant account? I can help you to get a merchant account at economical cost. We are one of the largest payment platform provider just entered in India and have office in Worli, Mumbai. Let me know.

    Rgds,

    Unmesh

  22. VaraK says:

    Happy birthday. Hope you are having some rocking moments.

  23. Magda says:

    Happy Birthday! Long and happy live to you

  24. Tan says:

    Namaste Chandoo,
    Happy Birthday (belated)... I also celebrated the same birthday, on 14th. 6 Days elder to you in age, but somehow younger in knowledge and achievements...

    I wish you all the luck in the coming years and thank you a lot for providing us with all the information.
    Regards,
    Tan πŸ™‚

  25. ButchJ says:

    Congratulations on your Birthday! I check your website out several times a week...it's great.
    This is a link to an Excel birthday countdown file I created today. Hope you find it useful.
    http://www.speedyshare.com/files/24811407/Birthday_List.xls
    ButchJ

  26. Pedro Wave says:

    A year is the orbital period of the Earth moving around the Sun.
    Congratulations on your twenty-ninth moving around the Sun!
    http://excelunusual.com/?p=406
    This is an awesome Excel Web with an impressive animation of a 3-Body Planetary System.
    It's a present for you made by my friend George. Enjoy it!

  27. Jennifer says:

    Congrats, Chandoo!

    May you have many more years filled with joy and happiness πŸ™‚

  28. Prasanna N says:

    Happy Birthday You Inspiring Entrepreneur!!! I wish you a very prosperous next year. Tonnes of thanks for the Inspiration. πŸ˜€

  29. salando says:

    Happy Bday Chandoo, Wish u many more prosperous, knowledge sharing and above all awesome years. Enjoy!

  30. DebbieB says:

    Hello Have a Happening Bithday
    Thank you for all your tips ++++
    I would have gone batty without you

  31. [...] Some of these examples are of novice people (1, 2, 3).Β  Some of these examples are of the experts (4, 5) in this field. Here I am talking about earning money or making money by creating and running a [...]

Leave a Reply