October Sale - 20% of all courses - Book Today

Coins and pens

8 SMART Tips for Financial Modelling

January 18, 2018

See below for our 8 top picks of smart financial modelling guidelines to live by

 

1- Ownership & Protection

In order to minimise risk and error it’s important that only one analyst builds and owns the model. Make sure that all old model versions are saved in a separate folder, these act as a back-up. If you password protect your cells containing formulas this will help to minimise end-user errors.

 

2- Set-Up

In the set-up of your workbooks make sure that you avoid having multiple workbooks where possible. All references to external links should be clearly identified and imported to an “input sheet”. Once this is complete reference as required.

Setting up your work books correctly is important in order to provide more transparency.

 

3- Structure

One of the best ways to structure your financial modelling workbooks is to set up your menu, inputs, calculations and outputs &reports in that order. In your menu make sure there are hyperlinks to all relevant sheets. For your inputs make sure that you clearly identify your cells for data entry. Your calculations are the engine room of the model and should be protected. Finally set up your outputs and reports.

 

4- Inputs

When setting up your inputs it’s important to make sure that they are separated from your calculations. This way users know exactly where they need to enter data. It also reduces the likelihood of a user inadvertently tampering with calculations. When inputting data it’s also important to make sure that you only input the data once and then always refer back to this cell. Therefore, future changes to this input only have to be updated once and this in turn avoids potential inconsistencies.

 

5- Formatting

When formatting your work books make sure that you are consistent in your formatting. This makes it easier for co-workers to get a handle on a new model if they are familiar with the formatting.

Consistent color coding and formatting of inputs is also a must.

 

6- Calculations

When it comes to calculations there are a number of things to keep in mind. Have a look at our list below:

- Simple is best - Always opt for formulas over VBA where possible - Aim to have one consistent formula on each row or column - Keep column and row headings consistent - Test your calculations as you build, add error checks - Limit the use of modelling tools such as spinners as they introduce an extra layer of complexity

7- Outputs

For your outputs, we recommend one summary sheet displaying all key results and metrics. You can always add additional reports, charts and dashboards to suit business needs.


8- Documentation

Models should be logical and self-explanatory but may require supporting documentation. Make use of comments and add user guidelines where necessary for more complex calculations.

 

Take a look at out Specialist Microsoft Excel Financial Modelling course to learn more skills.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23623 Reviews
Very good course - I learnt a lot. Tamara was really patient and helpful. -R Intermediate Brisbane
Elly - R Intermediate, .
Learnt lots good stuff to use for my work. Thank you -Excel Beginner Brisbane
Adam - Excel Beginner, .
Thank you for your time and it was very informative. Many Thanks -Excel Beginner Brisbane
Morgan - Excel Beginner, .
it covered all my needs. Thanks -Excel Beginner Brisbane
Rohan - Excel Beginner, .
Great learning and enjoyed . -Excel Beginner Brisbane
John - Excel Beginner, .
Very pleasant, informative day. -Power BI Beginner Brisbane
Bobbette - Power BI Beginner, .
This has been a very helpful introduction to Power BI - we'll be able to move some of our reports across to Power BI sooner than we expected. -Power BI Beginner Brisbane
Karen - Power BI Beginner, .
Great beginner session - trainer very personable. -Power BI Beginner Brisbane
Tracey - Power BI Beginner, .
Very helpful and hands on. A comprehensive look at the basics of PowerBI - definitely interested in learning more in the intermediate course. -Power BI Beginner Brisbane
Daniel - Power BI Beginner, .
Very valuable session. Can definitely see how we will use this in the workplace. Steven was a great trainer and kept the room going all day, -Power BI Beginner Brisbane
Amanda - Power BI Beginner, .
Steven was a great trainer. -Power BI Beginner Brisbane
Fay - Power BI Beginner, .
Great overview. -Power BI Beginner Brisbane
Barbara - Power BI Beginner, .
Very informative, the presenter was thorough and welcoming to all. I never felt uncomfortable asking questions. I am also grateful for the Course Manual, so I can review the Agenda topics again at my own pace. -Excel Intermediate Sydney
Janelle - Excel Intermediate, .
excellent teacher very impressed -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Very informative. Some great hacks -Excel Intermediate Remote Online
Matthew - Excel Intermediate, .
Thanks Michael, you were patient and happy to go back over knowledge whenever people needed it. I love how excited you got over some of the technical aspects - they were really interesting! Sometimes it was a little hard to hear, might have been connectivity issues on my end, not sure. Thanks so much! -Excel Intermediate Sydney
Kristie - Excel Intermediate, .
The topics chosen were very useful. I especially think the If statements, vlook up, pivot table and flash fill will work well for me in the future. Michael was very helpful and always stopped to assist those who needed further info. He was also happy to answers questions in general related to excel. Potentially needed some polls or questions within the training to check learning and understanding. -Excel Intermediate Sydney
Jessica - Excel Intermediate, .
Michael is very good teacher. It was a great session and learned a lot in a short time. -Excel Intermediate Sydney
Philip - Excel Intermediate, .
very good. Need to practice now -Excel Intermediate Sydney
David - Excel Intermediate, .
Jason gave us a really good overview of both Power BI service and desktop and was very helpful answering our questions. The course was very helpful in cementing and extending my basic understanding of Power BI -Power BI Beginner Canberra
Paul - Power BI Beginner, .

Trusted by Business

south east asia microsoft training courses nexacu

Follow us