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