Archive for September, 2008

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