Blog & Excel Tips

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.

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.