Skip weekends while autofilling dates in excel
Often you may want to fill a column only with weekday dates instead of all dates. Here is a simple trick you can use instead of writing nifty if formulas or manually entering the weekday dates. When you auto fill dates by dragging mouse (or using menu > edit > fill > series > selecting […]
Google maps 3d building outlines – wow
I haven’t noticed this before, but google maps provides 3d building outlines. I think this is pretty cool. You can see them in action here. Earlier on google : Google Park bench in Russia
Are you ready to solve problems differently?
Just a take a moment away from your job, graduation term project, cooking or cat petting – whatever it is that you are doing. Now think and tell me if you have any other interesting, exciting, simpler, cooler of way of doing the same? Just remove all your assumptions, forget anything you have learned about […]
Photographic Fridays #2 – Marbles
we are going…, originally uploaded by Chandoo. It was a lazy Saturday, my wife was having a concall related to work and I needed to pass sometime. While rummaging through the storage closet I found this old Chinese checkers board along with 60 marbles. Instantly I knew what to shoot.
Hot Thermometer Charts in Excel – here is a cool way to do them
Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent presentation slide or dashboard widget. What more, they are as simple to do as adding whipped cream to your latte. So lets begin: 1. First […]
Get Stock Quotes in Excel
While trying to spell check one my sheets I have learned this cool trick to fetch real time stock quotes without any webqueries or vba or anything. First enter the stock code in a cell (this works for US stocks only), for eg. AAPL for Apple, MSFT for Microsoft etc. Then ALT+CLICK on that cell, […]
Most bizarre print ads – Indian version
Time for another look at print ads, this time for the most bizarre of them all. Mind you, these are not awful or plain lousy ads, for any column-centimeter worth its area has a fair share of lousy ads, these are simply bizarre ads, the kind that will make you go – WTF? The first […]