Analytics Category 
Most bizarre print ads - Indian version
By Chandoo at 23 June, 2008, 6:37 pm | 2 Comments
Time for another look at print ads, this time for the most bizarre of them all. Mind you, these are not awful or plain lousy ads, for any column-centimeter worth its area has a fair share of lousy ads, these are simply bizarre ads, the kind that will make you go - WTF?
The first one [...]
on vlookup()
By Chandoo at 5 May, 2008, 2:36 pm | 0 Comments
Like this? Feel free to share / copy / exploit / save the cartoon. See other powerpoint cartoons as well
Read More >>Want to be an Excel Conditional Formatting Rock Star ? Read this
By Chandoo at 13 March, 2008, 8:50 pm | 69 Comments
Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and good looking. Better still, you dont even need to be a guru [...]
Read More >>Auto tagging your old blog posts
By Chandoo at 7 January, 2008, 12:00 am | 8 Comments
As you all may know I have recently moved my blog from blogger to wordpress. Since I have started blogging way back in 2004 most of my posts were untagged. I have used blogger labels ever since they were introduced, still almost 400 of my posts were untagged. I had two options,
Manually edit posts and [...]
Read More >>3 Steps to Create cool dashboards in excel
By Chandoo at 5 September, 2006, 1:02 am | 2 Comments
Dashboards are very common business monitoring tools, but creating them in excel with all the bells and whistles is not so easy. So here is a quick 1-2-3 on how to do it.
Lets take a sample of 2 consecutive year sales figures for 7 regions. The colums have Region name, 2004-05, 2005-06 figures and finally [...]
How to Get Unique Items using Excel
By Chandoo at 4 September, 2006, 2:18 am | 2 Comments
I recently had to perform some analysis on a set of insurance companies in certain geography. After searching the net I found such list of companies operating in that continent. But the problem is,
These companies are listed multiple times, one time for each of their geographical area of operation.
I cannot count each company only [...]
