Archive for March, 2013

There is an Easter egg in this chart!

Published on Mar 27, 2013 in Charts and Graphs
There is an Easter egg in this chart!

Do not worry, you are not time traveling or seeing things. Its just that, this year I have decided to publish our Easter Egg a few days early.

And oh, I have 3 reasons for it:

  1. 2 of my favorite festivals – Easter & Holi (a festival of colors, celebrated in India) are this week. Holi is today (Wednesday) & Easter on Sunday.
  2. My kids are super excited about Holi as this is the first time they will be playing it. So we have family time from today until Wednesday and I do not feel like writing a blog entry on Friday 🙂
  3. I like to have 3 reasons for everything.

Hence the Easter Egg is advanced a few days. But it is just as fun (or may be better) as previous Easter eggs.

Continue »

Join my Excel Dashboard Masterclass in USA [May-June 2013]

Published on Mar 25, 2013 in Excel Workshops

Advanced Excel & Dashboards Masterclass by Chandoo.org - USA 2013

Hello folks,

I have a super exciting news to share with you all. I will be conducting a series of Masterclasses on Advanced Dashboards & Excel in USA this Summer (May – June 2012). So if you live in (or nearby) Chicago, New York, Washington DC or Columbus OH, and want to one up your dashboard skills, you know what to do next.

I am conducting these masterclasses in partnership with PowerPivotPro.

Click here to know more and book your slot.

Continue »

How well do you know your Lookups? [Quiz]

Published on Mar 22, 2013 in Quizzes
How well do you know your Lookups? [Quiz]

So you think you know VLOOKUP formula? Well, test your knowledge.

Click here to take our first ever quiz – on Look up formulas.

Continue »

Finding Nearby Zipcodes using Excel Formulas

Published on Mar 18, 2013 in Excel Howtos
Finding Nearby Zipcodes using Excel Formulas

Recently, I had a peculiar problem. I have a list of zip codes and I wanted to find out nearest zip codes for each of them.

Now, If I wanted to find out near by zip codes for one area, I could go and search in Google. But, how to do it for dozens of them?

Today, lets understand how you can use Excel (that’s right) to do this automatically. We will be using Excel 2013 for this.

Continue »

How to remove all cells containing John (or anything else) [Quick tip]

Published on Mar 15, 2013 in Excel Howtos
How to remove all cells containing John (or anything else) [Quick tip]

Here is an interesting question someone asked me recently,

If I have to delete all rows with “John” in it. Do you know how to do it?

Well, it looks like they really hate John. But it is none of my business.

So lets go ahead and understand a dead-simple way to get rid of all cells with John or whoever else you fancy.

Continue »

Finding Conversion ratio using Pivot Table Calculated Items

Published on Mar 6, 2013 in Pivot Tables & Charts, Power Pivot
Finding Conversion ratio using Pivot Table Calculated Items

Today, lets understand how to use Calculated items feature in Pivot tables. We will use a practical problem many of us face to learn this feature – ie calculating conversion ratio from a list of sales calls.

Continue »

Work with several Excel files everyday? – Save them as a workspace [Quick tip]

Published on Mar 4, 2013 in Learn Excel
Work with several Excel files everyday? – Save them as a workspace [Quick tip]

If you work with multiple Excel workbooks everyday, then here is a handy tip.

Use Save workspace feature to save your workbook collection & layout.

Continue »