Custom Map Charts Thumb

Creating custom Map Charts using shapes and VBA

Whenever I see promotional images for expensive BI Dashboard software, they always show the same thing – a map with countries or regions highlighted in different colors.  It sends the subtle message that maps are the pinnacle of Business Intelligence (whether they are or not is a different matter altogether).  Until Excel 2016, these Map Read More

Get file name of current workbook thumb

Get the file name of the current workbook

There are times in Excel when we may want to display or use the file name of the current workbook, or maybe the name of a specific worksheet.  Whilst there are a variety of options none of them are particularly obvious.  This post will consider some of the possible options: Header/Footer section CELL Function VBA Read More

Edit links in Powerpoint using Excel VBA Thumb

Edit links in PowerPoint using VBA

In a previous post, we considered how to link Excel files to PowerPoint presentations.  This can be a significant time saver as the PowerPoint presentation can be updated automatically.  Once you have created the links, life is brilliant, until . . . you need to change which file the PowerPoint presentation is linked to.  You Read More

Make workbook read only for everybody Thumb

Make a workbook read-only for everybody but me

I was recently asked this question – “How can I make my workbook read-only?”.  I gave the person an answer.  However, the real question they were asking turned out to be “How can I make my workbook read-only for everybody but me”.  In this post, we will explore some of the options available.   Save Read More

Data-errors-rules-matrix-thumb

Quickly find errors in data using a rules matrix

Being able to analyze a lot of data quickly to find potential anomalies and errors is a skill.  We should not assume that the data we use in our spreadsheets is error free.  To make this assumption might be dangerous, especially if we are providing insights and advice based on that data.  But in a Read More