Blog & Excel Tips

Recent spreadsheet error showing how a spreadsheet error can change the information reported and relied on with investments.

Listen as I discuss the latest Microsoft Excel changes and new tools on the Financial Modelling podcast ... how Financial modelling is infiltrating all aspects of business, even in the detailed calculations of biotech ... thoughts on AI in MS Excel and whether Excel will ever be replaced!

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