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