I have noticed something totally strange while trying to get an auto insurance quote online at GEICO. See it for yourself.

They are showing your password in the URL… OMG
Make sure you don’t use the site for getting new quotes as it could be a potential privacy breach as anyone watching the URLs like [...]

Often my work involves processing web page data in excel sheets. This includes extracting the hyperlinks from cell contents. There is no formula for extracting hyperlinks though, you can right click on cell and choose “edit hyperlink” to see which address the cell is linking to. But that is a tedious process especially if you [...]

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 change sort [...]

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.

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 [...]

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).

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 for [...]