Blog & Excel Tips

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.

Correcting numbers in Excel with incorrect commas, points or spaces where the VALUE function does not work, using a new function in MS Excel.

Podcast- 50 Things That Made the Modern Economy- How a grid on a computer screen gives us a glimpse of the future of automated work

2 ways to convert the month number into the months name either just visually (format) or so that the cell contains the word instead of the number.

An annoying error when using Get & Transform (PowerQuery) in Excel is the overflow error as it is not always clear what it may be. The error says '[Expression.Error] An error occurred ...