Blog & Excel Tips

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.

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.