What are the best practices in MS Excel modelling?


1 Answer(s)


1) Avoid hard-coding values, always use formulae.

2) Give your spreadsheets structure.

3) Make cell content and cell purpose visually identifiable at all times. Use Color scheme like font colors to indicate if a cell is an input, a formula or a reference.

4) Build error checks into your Excel spreadsheets.

5) Avoid using Macros when they are not absolutely needed.

6) Try to have fewer sheets, with organized content in each of them.