Being in the field of finance, we often have to perform calculations, and develop reusable models in excel. This article summarizes and compiles the best practices that I have come across in my experience with excel modeling. Following these tips can make you better at excel modeling, and help you build more robust and error-proof financial models.

General

1. Keep learning your tool: Excel is an ocean and I haven’t come across anyone who knows everything about it. The more you learn this tool, the more you will be able to use it for various purposes.

2. Who’s your audience: You need to have a clear idea about who your audience is. Are you developing the model for yourself, an expert excel user, or a novice? This will help you decide what level of details you need to put in.

3. Life of the model: Are you going to use the model for just a few days, or is it something that you can use for a long time? This is very important because you don’t have to spend innumerable hours on perfecting something that you want for just one day. Depending on how long it will be useful, you can make it more sophisticated.

Excel Specific  

4. Layout: You model should have a clean layout, with inputs on one side, and output cleanly organized separately.

5. Color scheme: Follow a color scheme consistently. One scheme is: keep all calculated values (and titles) in black, user inputs/assumptions in blue, and references/sourced assumptions in green.

6. Assumptions and data validation: All assumptions about the inputs should be clearly stated in the form of comments. Use the data validation feature to avoid accidental wrong input by the user.