Archive for December, 2008

Camera tool is your way of creating visual reference in an excel sheet. It is one of the useful and hidden features of excel. Here is how it works. You specify a rectangular area in your workbook and camera tool creates a mirror image of that area as a drawing object. You can move it or resize it. And whenever the contents of original rectangular area changes (charts, drawings or cell values) the mirror image changes too.

Here is a simple question you should ask when you set out to make a new chart. Are you making a BLOW chart? Blow? what blow.. you may ask. BLOW stands for Blinding Light of Obvious Wisdom. In other words, a blow chart tells nothing. It is there just for the heck of it. I […]

November 2008 has been the best month since I started this blog and thanks to all the readers and commenters for your tremendous support.

We had 33 posts and 331 comments (highest ever). We also had 150,000 page views, 50% more than last month and highest ever. Our RSS subscriber base is now at 1750 and growing everyday. This is a great feeling and I couldn’t have done any of this without your constant support and motivation. I am thankful to each and everyone of you for helping me learn and share whatever I can.

Every Monday PHD shares some of the best excel related articles around the web so that you are up to date with discussions and new ways to be productive. Here is a list of links recommended for this week.