An Excel update means you can now unhide multiple sheets in Excel at the same time. Learn how, which versions allows this and an alternate if you are not yet on the current version.
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.
Another example of the risks with leading zeros. In Denmark, 9000 people were not contacted with regards COVID vaccines as there ID numbers started with a zero.
Ideas on easy ways of finding the IFERROR, ISERROR, ISERR, ISNA, ISREF, IFNA errors, in order of riskiness, when auditing a financial models.
If you have a problem with your Excel spreadsheet being extremely slow, you may have an issue with hidden name ranges. So if you find that a simple move from one cell to another with the arrow key takes longer then you want, this may be the solution.
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."