Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
When displaying results, especially variances or percentage variances you may want to show + or - sign in MS Excel cells
The possible reason for PowerQuery Create Connection Only being Greyed Out, and how to make it available again.
South African Actuarial Hard Coding Error In Excel Oct 16, 2019
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
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."