Modeling best practices

Modeling best practices

8 October 2016

This article presents an overview of recommended Excel modeling best practices:

  • Use a simplified SDLC for spreadsheets.
  • Use a simplified Version Control process.
  • Focus on reducing points of failure.
  • Reuse pretested standard formulas and templates.
  • Use self-documenting formulas.
  • Use tool-tip documentation.
  • Reduce data entry errors.