Changing Sort Orientation in Excel – Sorting across columns instead of rows
change-sort-orientation-excel-columns You can sort data across columns instead of rows by changing sort options. If you ever had to sort across columns now you know a simple way to do this 🙂 Follow these steps for changing sort orientation: Select the table you want to sort (just the data, not the headers as when you […]
Google Maps adds directions by Public Transport – Wow
Wow, this is awesome. Google maps has added directions by public transport. Sometime back when they integrated public transport timings along with bus-stop / train station icons, it was pretty cool, but adding directions based on bus / train routes is totally awesome. Try it for yourself, click here to see a sample direction.
Excel Links – to iPhone or not to iPhone edition
We have been debating whether or not to buy iPhone. For one, we are not on any cellular contract and free to go. But the sheer cost of $400 one time (one for my wife and one of me) and a monthly bill of ~ $150 is holding us back. Our current mobile bill is […]
Excel Bullet Graphs
Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics. Howmuchever effective they are, the sad truth is there is no one easy way to do them in excel. I have prepared a short tutorial that can make you a dashboard ninja without writing extensive […]
Photographic Fridays #5 – Dawn
During my evening jogs I go past this place, its a patch vast open space in the midst of the urban land. I made a mental note to shoot here during early morning as I would get very good view of sky. Yesterday I woke up early and drove there to took some shots. The […]
Awesome folks at flickr introduce instant zoom for photos
Wow, this is one of the coolest features on flickr, you can use instant zoom to see finer details of pics (the ones which have all sizes allowed for anyone).
Improve your in-cell charts with colors and negative values
In response to Making Incell charts better article, reader Tony mailed me an excel sheet in which he has modified the charts to display colors and negative values. This is pretty cool. Take a look at the chart below: The trick lies in displaying the charts in 2 rows, one for positive values and another […]