hacks Category 
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 >>Custom Cell Formatting in Excel - Few Tips & Tricks
By Chandoo at 25 February, 2008, 9:55 pm | 13 Comments
The other day I had to make an excel sheet for tracking all errors across one of the applications we are doing for our customer. The format was something like this,
We wanted to use a consistent message id format [4 digits: 0001, 0002, ... , 1000 etc.]. Now I do not want to type “0001″ [...]
Read More >>How I redirect traffic from blogger pages to wordpress posts
By Chandoo at 11 January, 2008, 4:55 am | 5 Comments
After moving the blog from the blogger to wordpress, my first challenge was to organize the posts for better discovery and search. I have done that by automatically generating tags and tagging posts using a bit of analysis and a bit of insanity.
The next challenge was to redirect the traffic from the old blogger [...]
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 >>Moved to Wordpress from Blogger
By Chandoo at 23 December, 2007, 4:08 pm | 5 Comments
4 days of Christmas break without a thing to do. The first thing that came to my mind is to revamp my blog. I have been thinking of upgrading the blog (yes, thats right, upgrading) to wordpress from blogger for a while now. Since my blog is hosted on another site through ftp, there is [...]
Read More >>The Art of Excel Charting
By Chandoo at 27 June, 2007, 8:10 am | 3 Comments
Yesterday while going through my feeds, I have landed on this post about the demographics and use-figures of various social networking (2.0) tools, et al (by businessweek) on think:lab blog. When I looked at the BusinessWeek’s graphical representation of demographics and usage figures of social networks, the first thought that came to me is, “well, [...]
Read More >>Say NO to Default Charts Forever!
or Excel Charting Hacks # 2Roughly 35-40% of my working time in office is spent with powerpoint. As one of my mentors said, powerpoint gives neither the power nor the point. Apart from writing truck loads of bullet points and using auto shapes, I also work alot with numbers and charts. Obviously I resort to [...]
Read More >>
