Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the visualizations featured earlier. Anatomy of a Great Speech – Obama’s acceptance speech at DNC Presentation Zen captures Obama’s symphony like acceptance speech in a graph shown […]

With each passing day the amount of information contained in a single spreadsheet, slide, document is growing. Thanks to demanding bosses, clients and colleagues, we are now supposed to provide all the relevant information in as much less space as possible. This is where micro charting or light weight data exploration has become a rage. […]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. This 6 Part Tutorial on KPI Dashboards Teaches YOU: Creating a Scrollable List View in Dashboard Add Ability to Sort on Any KPI to the Dashboard Highlight KPIs Based on Percentile Add Microcharts to KPI Dashboards Compare 2 […]

Often it is easy to get carried away with a tools features. Excel is no exception. But here is a list of grotesque charts that you should never make, not even on your last day at work. 1. Leave the radar charts for Spidermen why? You can hardly conclude anything by looking at them They […]

Often when you are processing customer records or doing mail merge, it might be useful to get initials from a given name, like JFK for John F Kennedy. You can do this using simple text formulas (left(), mid(), find()) combined with if(). Here is how: Assuming cell B3 has the full name, then this is […]

It has been a while since the blog’s look and feel has changed. The number of visitors to blog has been doubling for the last 2 months. I felt the need for a simpler but more elegant blog look and feel. So during the labor day weekend I have spent a few hours and changed […]

Took this near Niagara falls, NY. The falls are divided between US and Canada. You need a Canadian visa (US visa) if you want to see the water falls from both sides. Of course, water doesn’t need a passport to flow. Browse other.