White Paper

Make Excel Audit Proof: How to Effectively Manage Spreadsheet Risk

1 Introduction

  • Recent Excel «incidents»
  • Regulation

2 Version Control

  • _Tom_final_v2.xlsx
  • Version control for Excel
  • Peer Reviews and Git Integration

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

*
Please provide a valid first name
*
Please provide a valid last name
*
Please provide a valid company
*
Please provide a valid business email