Archive for December, 2008

What is camera tool and how to use it? [spreadcheats]

Published on Dec 2, 2008 in Charts and Graphs, Learn Excel
What is camera tool and how to use it? [spreadcheats]

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.

Continue »

Are you making Blow charts? [charting tips]

Published on Dec 2, 2008 in Charts and Graphs

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 […]

Continue »

Best of Pointy Haired Dilbert – Nov 2008

Published on Dec 2, 2008 in blogging, Learn Excel
Best of Pointy Haired Dilbert – Nov 2008

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.

Continue »

Excel Links of the Week [Dec 1]

Published on Dec 1, 2008 in excel links

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.

Continue »