White Paper: Make Excel Audit Proof

How to Effectively Manage Spreadsheet Risk

Content

1 Introduction

  • Recent Excel «incidents»
  • Regulation

2 Version Control

  • _Tom_final_v2.xlsx
  • Version control for Excel
  • Resolving version conflicts

3 Automated Testing

  • The directory of horror: «John_handover»
  • Test-driven development
  • The missing piece: Python with xlwings
  • A simple unit test
  • Model validation: Testing alternative implementations
  • Cell logic validation

4 Conclusion