Excel Links – Happy Birthday Edition
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.
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.
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)
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.
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.
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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Learn an Excel Feature: Picture Links (or Camera Snapshots)||FREE Excel Financial Model for Analyzing an IPO – Download Today »|