Blog & Excel Tips

An annoying error when using Get & Transform (PowerQuery) in Excel is the overflow error as it is not always clear what it may be. The error says '[Expression.Error] An error occurred ...

With the holidays coming it is time to relax. This is a Kids Treasure hunt (built in Excel) which we have converted to web pages where you can (easily even if customised to your house) create a scavenger hunt with different puzzle types.

Linking cells between WORKBOOKS and why links to other excel workbooks always looks at the same cell whereas links to sheets correctly moves.

Developing a financial modelling strategy that supports business goals- transcript from the live presentation by Adrian Miric

The answer to the question "what software package must I make sure that my kids learn"

A method to see, and play with the Excel data when PowerQuery editor is open or open 2 PowerQuery windows at the same time.

The European Spreadsheet Risk Interest Group Conference (EuSpRIG 2019) will be held on 11-12 July 2019 in London. Real life case studies of EUC control and deep dive into data analysis,

Occasionally you may want to print everything again but you don't want to clear the print areas and then reset them once you have a full print.