How to install or uninstall an Excel Add-in

Excel Add-ins are mini-software applications which provide Excel with enhanced functionality and automation features.  Whilst they can be created by third-party suppliers, even Microsoft themselves develop add-ins to provide additional functionality. Add-ins can take a number of forms: Excel Add-ins – typically these are Excel files saved with .xlam or .xla file types.  They can Read More

Calc Buddy Add-in

Many users experience the issue where Excel’s calculation mode changes without warning and without them realizing it. That’s pretty bad, right!< Due to the way Excel handles the calculation mode, the problem can easily be transferred to other workbooks, which can result in users issuing error-filled reports and quoting incorrect numbers.  That’s also pretty bad, Read More

The fastest way to create Bullet Charts

My first experience of Bullet Charts came from reading Information Dashboard Design by Stephen Few in 2007.  This was the year I started to get serious with dashboards. Initially, to create Bullet Charts I used the 3 stacked bar/column charts approach.  Later, I moved to using the two-axis stacked column where possible, but in general, Read More