Blog & Excel Tips

An Excel update means you can now unhide multiple sheets in Excel at the same time. Learn how, which versions allows this and an alternate if you are not yet on the current version.

Another example of the risks with leading zeros. In Denmark, 9000 people were not contacted with regards COVID vaccines as there ID numbers started with a zero.

Ideas on easy ways of finding the AVERAGE, MIN and MAX errors, in order of riskiness, when auditing financial models.

3 errors that can (and do) happen in the simplest of SUM functions.

Excel never dies and the spreadsheet will never die!

Ideas on easy ways of finding the IFERROR, ISERROR, ISERR, ISNA, ISREF, IFNA errors, in order of riskiness, when auditing a financial models.

If you have a problem with your Excel spreadsheet being extremely slow, you may have an issue with hidden name ranges. So if you find that a simple move from one cell to another with the arrow key takes longer then you want, this may be the solution.

When reviewing a financial model it is important to understand easy ways of finding the SUBTOTAL and AGGREGATE errors, in order of riskiness.