When performing financial model reviews on SUMIFS, COUNTIFS, AVERAGEIFS it is important to understand the typical errors people make in priority order. This way you can find the typical financial model errors quickly.
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 performing a financial model review on VLOOKUP, HLOOKUP, and LOOKUP, you can prioritise which formulas to look at first based on the common spreadsheet errors made in this area.
How to manually find all the Excel functions prone to spreadsheet errors and a listing of the high risk functions with their likely error.
How to find cells with external links in Excel Dec 21, 2020
... sometimes you want to find which cells in Excel are using external links. This could be so that you can delete them, remove the link or just better understand what impact the external links are having on your spreadsheet. This post is a description of how to find cells with external links in excel.
You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line break is where, within a single cell, text appears on two seperate lines.
How to use multiple characters as delimiters in Excel's Text to Column tool, when Excel only allows a single character entry.
What gets lost when repairing a corrupt Excel file Nov 13, 2020
If you are forced to repair an Excel file and save it as a new version, it is useful to know what is lost when repairing a corrupt Excel file.
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."