Knowing what good looks like can be part of the problem when it comes to reviewing a spreadsheet. Individuals don’t often know what they don’t know and this can lead to reviews not catching the errors that they should be.  Jonathan Swan, Operis’ financial modelling trainer, contributed to The Institute of Chartered Accountants in England and Wales (ICAEW) report on “How to review a spreadsheet”.  The ICAEW make it clear that checking, auditing, validating and, if necessary, correcting legacy models is not a ‘nice to have’, but a ‘must-have‘ skill analysts need in 2022.

In this Podcast Jonathan sets out the five key stages of the review process:

  1. Initial Review
  2. Structure Review
  3. Data Review
  4. Analytical Review
  5. Detailed Review.

Johnathan talks you through what needs to be completed during each stage. As well as highlighting some of the most common errors he comes across during his reviews and how analysts can avoid making them.

Share now

CONTACT US

Please get in touch with either of our regional offices.

https://www.operis.com/wp-content/uploads/2021/01/Erwan-Fournis-500x500.png
Erwan Fournis
Global Head of Financial Advisory

+44 207 562 0444

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/05/Carmen-Wade-500x500.jpg
Carmen Wade
Financial Advisory, Head of North America

+1 647 243 3840

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/03/Jun-Tao-500x500.png
Jun Tao
Global Head of Model Audit & Financial Modelling

+44 207 562 0428

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/04/Michael-Jarman-1.jpg
Michael Jarman
Head of Modelling

+1 647 243 8016

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/05/Philip-Allen-500x500.jpg
Philip Allen
Head of Training [javascript protected email address]

Operis Europe

View Google Map
+44 207 562 0400
[javascript protected email address]

Operis North America

View Google Map
+1 647 846 7382
[javascript protected email address]

CONTACT US

Discuss your requirements with us

https://www.operis.com/wp-content/uploads/2021/01/Erwan-Fournis-500x500.png
Erwan Fournis
Global Head of Financial Advisory

+44 207 562 0444

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/03/Chirs-Aldred-500x500.png
Chris Aldred
Director

+44 207 562 0433

[javascript protected email address]
Name(Required)
Consent(Required)
This field is for validation purposes and should be left unchanged.