I am coffee drinker. And I love various types of coffee; be it the Chennai strong filter coffee or the medium-blend of Starbucks, I just love to sip a cupfull every morning. Since I love coffee so much I thought why not share a little secret about coffee buying with you all. Assuming you buy […]

Spelling mistakes are a thing of day to day carporate life. Most of the data in spreadsheets is entered by people and hence prone to having spelling mistakes or alternate spellings. For eg. a person named John could have been spelled as Jon. And when John calls you back to confirm his reservation and you […]

In shuffling a list of items in excel I have described the technique of using random numbers generated by RAND() to sort a list of items. The technique had one disadvantage though, every time you need to reshuffle the list you have to press F9 to recalculate the rand() and then go to menu > […]

Gmail Labs constantly introduces new features that make using Gmail much more productive. Recently they introduced 2 new features – Mark as Read button and Auto suggest for label search which I find extremely useful. Mark as read is really useful since I use it often to get to inbox zero. I am obsessed with […]

Often when you are working on 2 incompatible systems and try to import data from one to another, excel can be a handy tool. I have used excel plenty of times to generate SQL insert / update statements which I could later execute on the database console. Here is a tutorial if you ever have […]

As mentioned earlier we have moved to Seattle this Sunday. It seems like a great place already. Just that everything is more expensive than we are used to in Columbus. But I guess that is the premium we have to pay for being in a big city. On to this week’s edition of excellent excel […]

Last week we have been to Pittsburgh to visit a college friend. We had great fun there. It is a neat little town with countless bridges. Pittsburgh was historically known as steel city, but today the glory is all that of technology and education industries there. The above is the building of a steel company […]