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 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 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.
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."