Blog & Excel Tips

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.

... sometimes you want to find which cells in Excel are using external links. This could be so that you can delete them, remove the link or just better understand what impact the external links are having on your spreadsheet. This post is a description of how to find cells with external links in excel.

You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line break is where, within a single cell, text appears on two seperate lines.