Archive for How-To


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

10 tips to improve your Excel dashboard

Excel is a great (but underrated) BI tool. Several BI vendors gave up fighting it and offer Excel add-ins as front-ends for their BI solutions. So, if you want to create a dashboard you should consider Excel, since it really offers better functionalities than many other applications for a fraction of the […]

How-to screencasts: Population pyramids in Excel

Screencast: How to create a population pyramid in Excel.
I am a big fan of screencasts, as a regular reader of this blog may have already noticed. They are great at showing how to use a tool to get something done and they are the best companions for tutorial (e-)books.
This hypotetical regular reader might also […]