Blog & Excel Tips

Alternates to face to face training and consulting while the COVID-19 threat is addressed.

If you are stuck at home due to COVID-19, some suggestions and ways to keep being productive and some amusement for your kids.

AuditExcel is visiting Kigali in Rwanda on the 23rd-25th Feb 2020. If you need MS Excel services lets try and get in touch.

The most used functions in MS Excel, understanding why this is and what they do, and links to all the information we have on these functions.

We have created a free 'Excel hacks in 2 minutes per week' series that will teach you the tips and tricks of MS Excel in 2 minutes per week.

MS Excel Training prices for 2020. If you need to plan your training, look at when the public MS Excel courses are available in Johannesburg, Pretoria and Cape Town.

Free download of the South African Tax Spreadsheet Calculator 2020/ 2021 with salary versus dividends optimisation calculation. COMING SOON WHEN ANNOUNCED.

When using PowerQuery and getting 'Files from a folder', there is a risk that your query will break if the files in the folder do not start with exactly the same file name. In this post an easy fix for promoting headers when names can change.