Model Audit

Auditing workshops are designed for professionals involved in accounting and auditing who would like to utilise effectively the powerful features of Excel. The workshops explore the use of Excel as an audit and analysis tool, as well as selected features that help prepare accurate reports and work papers.

The use of Excel as a tool for auditing can be applied in many different areas, such as investment appraisal, capital planning, budgeting, valuation, financial analysis and forecasting. In all cases, our workshops improve the accuracy of financial models.

Example Workshop

This workshop explores:

• Aims and outlines governing model design and construction
• Designing and building in accuracy from the outset
• Techniques for efficient construction to provide inherent reliability and robustness
• Range of auditing methods
• How to review files efficiently

After the workshop, participants will be able to use a structured method to review and audit models, find errors and report on structural and coding weaknesses. Here is an example review report on a model showing errors and inconsistencies in different sheets: