It is well-documented that up to 90% of spreadsheets contain errors and although any individual mistake may be small, they can quickly add up. Checking for errors is an important part of the financial model build and there are many native Excel tools that can be used for this purpose.
Watch to hear from Mazars financial modelling specialist trainer, Joshua Grimm for a deep dive into best practice review techniques and how to practically apply these to the model review process. We take a look at the best features native to Excel for reviewing spreadsheets, the strengths and weaknesses of each of the tools and provide guidance on when each tool is best. Joshua also explains how each of the tools have been used to find errors in “real life” examples, and demonstrate which tools are best for different scenarios.