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 Excel’s calculation mode keep changing?

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

Automatically open workbooks thumb

Automatically open workbooks when Excel starts

There are a lot of circumstances where it is useful for a specific workbook, or workbooks to open whenever Excel starts: Save time by opening workbooks you always use To control the calculation mode To trigger VBA events when you open Excel This isn’t just something interesting you can do with Excel, it’s actually a Read More