
RSS feeds are everywhere. So much that you cannot avoid them in your data processing, analytics or day to day spreadsheet needs.
If you can get the RSS feeds to excel sheet you can do pretty interesting things with it, like:
Prepare a sheet to watch deals on Amazon, Craigslist, Deals2buy and other favorite sites
Watch news, [...]

Wow, this is totally cool. A great lesson in creating buzz.
The folks at windows vista wanted to convince people that Vista is indeed a good operating system and upgradable from XP. But there are lot of bad opinions floating around and end users are more or less confused about it. Personally I have rarely used [...]

Here is a quick round up of excel posts from few of the awe some blogs around the web:
At PTS Blog, Jon provides excellent tutorial on adding target lines to your bar charts to show target vs. actual performance. He has several other tweaks for your category axis as well, just read the other posts [...]
Starting this week I will post cool infographics from around the web, 4-5 of them a week to inspire , to give more ideas on presenting information and to provide some eye candy for awesome readers @ Pointy Haired Dilbert.
Go ahead, click through these awesome graphics:
California Walkability Score Heat Map
Lee Byron took the [...]

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.
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 [...]
21 Jul
in Analytics, Excel Tips, hacks, ideas, technology, visualization 5 Comments

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