Excel formulas can always be very handy, especially when you are stuck with data and need to get something done fast. But how well do you know the spreadsheet formulas? Discover these 15 extremely powerful excel formulas and save a ton of time next time you open that spreadsheet. 1. Change the case of cell […]

My Olympic medals by country year visualization in excel is received well by readers. I got few interesting emails on it. Robert from Germany shares an interesting approach at doing this, by doing a heat map of the medal counts on an outline world map. This is very impressive and involves flood filling countries with […]

I use google suggest to get new post ideas, I start out by typing “what is”, “who is”, “how to”, “when is”, “where is”, “excel” and see all the suggestions Google comes up with. If I see something interesting I would mark the search topic and use it for posting here. And for the last […]

Next time you want to make a chart to tell how your sales (defects, customer calls, page views, number of clicks, walk-ins etc.) are doing over a period of time, consider showing them in a min-max chart. For eg. a min-max sales chart for the last 12 months tells average, minimum and maximum sales per […]

This is another wow feature in Google maps that I started seeing last week. You can search restaurants by cuisine, how simple yet how effective .. 🙂 Click here to see all the Pizza places near Empire State Building in New York. Earlier on Gmaps: Get directions by public transport, See 3D building outlines in […]

Every Friday I post a photograph to share it with my readers and get review comments. The above photo was taken when I visited Columbus Zoo last Saturday.

Time for another week of ogling at cool visualizations. What a week it has been for the chart makers 😉 Super cool visualization of 2008 Box office collection This is an area chart modified to indicate how a movie has performed everyweek, thus the movie markers go down (except for dark knight) after 1-2 weeks […]