Modeling best practices

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.