Blog & Excel Tips

Recently we discovered a way to trick Excel into performing some tasks quicker. So if you experience a slow Find/ Replace, Spell Check and GoalSeek in Excel try this option.

If you, or someone you know, is in the inbetween stage between school and university, or university and work, or school and work, it is a good time to look at preparing for these new stages in your life and a bridging Excel course will be an invaluable tool.

Free download of the South African Tax Spreadsheet Calculator 2021/ 2022 with salary versus dividends optimisation calculation taking into account PAYE, SDL and UIF.

Please note that the Excel auditing software, 'Spreadsheet Professional' will no longer be supported by us. With Spreadsheet Innovations no longer supporting the tool, we have moved onto a new Excel auditing tool.

Ideas on easy ways of finding the IF errors in financial models, in order of riskiness, when auditing an Excel based financial model.

When performing financial model reviews on SUMIFS, COUNTIFS, AVERAGEIFS it is important to understand the typical errors people make in priority order. This way you can find the typical financial model errors quickly.

When performing a financial model review on VLOOKUP, HLOOKUP, and LOOKUP, you can prioritise which formulas to look at first based on the common spreadsheet errors made in this area.

How to manually find all the Excel functions prone to spreadsheet errors and a listing of the high risk functions with their likely error.