Archive for features

You are browsing the archives of features.

Performance vs flexibility in Excel: Demographic Dashboard Lookup Edition

I am sure Albert Einstein was thinking of Excel dashboards when he said “everything should be made as simple as possible, but not simpler”. Let me tell you why.
Demographic Dashboard: The VBA edition
I published some time ago a first version of my Demographic Dashboard to show how an average Excel user could design a […]

Creating a VBA-free Excel dashboard

Do you need VBA to create an Excel dashboard? Our recent discussion clearly shows two lines of thought: a) you should use it because there are things you just can’t do without VBA and if you have access to a powerful tool you should put it to work; b) you should avoid VBA like the […]

How to create a thematic map in Excel

How do you create a map like the one above for your next presentation if you don’t have a mapping tool? Simple, create it in Excel. Easier said than done, right? Well, not really…
Following the “geo-scatterplot”, in this screencast tutorial I’ll show you how to create a thematic map and color-code it, based on your […]

How to create a dashboard in Excel

Too often Excel is overlooked as a valid Business Information tool. Too often organization turn to expensive, proprietary BI solutions-that-become-problems after many months of expensive development. Too often the hidden agenda of some clueless IT dismiss Excel because of some stupid reasons. Excel is a powerful tool that can handle probably 80% of the business […]