Archive for June, 2008
Skip weekends while autofilling dates in excel
By Chandoo at 30 June, 2008, 7:23 pm | 11 Comments
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
By Chandoo at 30 June, 2008, 4:55 pm | 0 Comments
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?
By Chandoo at 27 June, 2008, 5:29 pm | 0 Comments
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 [...]
Read More >>Photographic Fridays #2 - Marbles
By Chandoo at 27 June, 2008, 12:03 pm | 6 Comments
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.
Read More >>Hot Thermometer Charts in Excel - here is a cool way to do them
By Chandoo at 26 June, 2008, 3:18 pm | 7 Comments
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 we [...]
Get stock quotes with one click in excel, and company profiles too
By Chandoo at 24 June, 2008, 7:37 pm | 4 Comments
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, [...]
Read More >>Most bizarre print ads - Indian version
By Chandoo at 23 June, 2008, 6:37 pm | 2 Comments
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 one [...]
