Blog & Excel Tips

Due to the existence of various software systems, you often need to get numbers to match each others signs. You will therefore need to know the Excel formula to change negative to positive (and vica versa) in spreadsheets.

With the recent announcement of VAT in South Africa changing from 14% to 15% on the 1st April 2018, it is important that you start looking at the new prices you will be charging. To help we have created a simple South Africa VAT Calculator

Your Excel sheet slow yet the spreadsheet is small. You could have inadvertently pasted some objects into your sheet that is processing heavy.

Free download of the South African Tax Spreadsheet Calculator 2018/ 2019 with salary versus dividends optimisation calculation.

If you have had the experience of Excel shutting down when opening a file you must know how frustrating it is. We experience it regularly, probably due to the size of the spreadsheets we build. However, it is sometimes even a small spreadsheet that perhaps contains a data table.

How to perform an IF not equal to in Excel for text and/ or numbers. Can be used in a multitude of functions including IF, SUMIF, SUMPRODUCT etc

We have recently completed a number of IFRS Excel Calculators relating to assessing the possible impact of IFRS 15 and 16 on the financials of a listed entity.

But when it comes to dates and times, you may have created some sort of tracking spreadsheet that needs to warn you once a certain date/ time is approaching. Is there a trick to auto refresh Excel every minute (with no VBA)?