Blog & Excel Tips

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

How to use MS Excel to cope with the current bout of Eskom load shedding and keep your business going.

PowerBI is all the rage, but most people don't seem to realise Microsoft's Power tools are available within Excel already. ... the most important one is there and ready to work. PowerQuery (now called Get & Transform) is ground breaking. Reasons to learn it include ...

If you build financial models, you may need to answer a question like when is the first time we go positive, or when was the first non zero value in a MS Excel list.

Below is a link to a simple Compound Annual Growth Rate (CAGR) calculator built in MS Excel with a proof to give you comfort that the number is correct.

When working with MS Excel's Power Query/ Get&Transform you may find that you want to change the Load format. However you may find yourself asking why Power Query close and load to is greyed out

... problem relates to the Data Table number formats not working. If you try and custom format the numbers it ignores it and if you have numbers in millions it seems to only differentiate the first thousand.

MS Excel Training dates for 2019 including the prices and venues in Johannesburg, Pretoria and Cape Town.