Blog & Excel Tips

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.

When working in Excel, you may wonder how to put m² in Excel cells so that it looks like metres squared instead of just m2. It is surprisingly easy. Below what the text looks like normally and with the superscript.

SUMPRODUCT only visible cells, typically for weighted average calculations, so that you can see the differences between the average on all and visible cells

When displaying results, especially variances or percentage variances you may want to show + or - sign in MS Excel cells

There is a fallacy that the solution to all your MS Excel problems is only learning keyboard shortcuts (CTRL + something) and other combination of keystrokes. Our view on this MS Excel shortcuts fallacy.

The possible reason for PowerQuery Create Connection Only being Greyed Out, and how to make it available again.

South African example involving hard coding error in a spreadsheet based actuarial calculation, and understanding how it could have happened.