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.
31 Responses
Congrats! Enjoy your birthday!
Happy Birthday Chandoo
I hope your next year exceeds your dreams and expectations
Hui…
have a wonderful bday!!
Happy Brithday Chandoo….
Hope you have a better year ahead
Love
Rajatha
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
Happy Birthday, Chandoo. I hope that your next year is as prosperous as your last one!
Happy Birthday!!!!!
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.
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.
Happy Birthday Chandoo !!! You are so young !!! But so successful ! 🙂
Enjoy your sweet 28 ! 🙂
Happy Birthday! Hope your birthday blossoms into lots of dreams come true!
Have a great one! Thanks for all the assist you provide. Hope your biz doubles in size next year.
Happy Birthday Chandoo
Congratulations and keep sharing with us your experiences.
happy birthday!! 🙂
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
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
Happy Birthday Bro.
Wish you a very HAPPY BIRTHDAY to you
wishing you a very-very happy b’day chandoo
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
Happy birthday. Hope you are having some rocking moments.
Happy Birthday! Long and happy live to you
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 🙂
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
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!
Congrats, Chandoo!
May you have many more years filled with joy and happiness 🙂
Happy Birthday You Inspiring Entrepreneur!!! I wish you a very prosperous next year. Tonnes of thanks for the Inspiration. 😀
Happy Bday Chandoo, Wish u many more prosperous, knowledge sharing and above all awesome years. Enjoy!
Hello Have a Happening Bithday
Thank you for all your tips ++++
I would have gone batty without you