Charting tips when in rush thumb

Excel charting tips for when you’re in a rush

Creating advanced charts in Excel can take a bit of time, as there are so many things to change.  Recently, I had to prepare a financial presentation quickly, like really quickly.  I knew exactly which charts were required (I had been given very clear instructions) and I knew how to do them (which is always Read More

Most dangerous Excel features thumb

The 7 most dangerous Excel features

“With great power comes great responsibility”, or so we are told in the Spider-man comic book and movies.  Microsoft, in Excel, has given us some very powerful features; features which save time, features which make Excel easier to use, features to produce amazing documents.  However, these features, in the wrong hands (or even in the Read More

Advanced Excel Essentials in the real world thumb

Advanced Excel Essentials in the real world

A few months ago I wrote a review of Jordan Goldmeier’s Advanced Excel Essentials. I had a project recently, which I thought this approach would be ideal for.  This post is to tell you how I got on. Since reading Advanced Excel Essentials I have also taken Jordan’s Excel Dashboard Pro video course.  This course Read More

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

Calculation mode changes thumb

Why does the calculation mode keep changing?

You’re probably aware that Excel has two main calculation modes: automatic and manual. Automatic calculation re-calculates the workbook each time a value changes, or based on specific actions (such as inserting, deleting, hiding rows/columns, or renaming a worksheet). Manual calculation only re-calculates when specifically requested by the user.  Formulas -> Calculation -> Calculate Now (shortcut Read More