Generate organization charts in excel – howto?
Here is a ridiculously simple workaround for those of you trying to generate an organization chart in excel: Use google org. chart widget instead 🙂 [If you are reading this in a feedreader this post may not display properly, visit the post page instead.] Open a new google docs spreadsheet (or work on the example […]
How to get more colors in excel chart – simple trick
Here is a simple to trick to beat the 56 color limitation in excel when you are designing a chart: use picture files (jpg, gif, png etc.) to fill the chart area. You will no longer have to worry about limiting your project report / website / annual report etc. colors to the 56 that […]
Change cell formats with find-replace in excel
Do you know that you can use excel find – replace dialog to change cell formats? Often we prepare a report or project plan and our boss or someone else in the team feels that all the red color cells need to change to blue or something similar, worry not, you can use find-replace (ctrl+h) […]
Custom Cell Formatting in Excel – Few Tips & Tricks
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 […]
How to: sharing trip expenses using excel
Yesterday we were calculating our Washington trip expenses and it occurred to me that if there is an excel template where I could enter the trip expenses and who paid what to find out how much we need to pay up / collect, it would be great. I looked around for few seconds, couldn’t find […]
How I redirect traffic from blogger pages to wordpress posts
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
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 […]