Financial Modelling in Excel

This section shows you how to set up a financial model properly. This is the foundation on which all of your other analysis will be built.

It covers concepts like:

• Model structure – Profit and Loss, Balance Sheet and Cashflow statements
• Financial model formatting and best practices
• Using Range Names
• Maximising your model’s flexibility
• Using Tables
• Creating, editing, finding and maintaining links between workbooks
• Building larger models
• Auditing your model
• Creating Charts
• Shortcuts

Now that you understand how to set up a financial model properly, you start looking at the detail of setting up data analysis so that your model can produce the key output of period financial statements.

This section covers:

• Financial functions – SUM, SUBTOTAL, NPV, IRR, XIRR etc.
• Lookup functions – INDEX, VLOOKUP, HLOOKUP, MATCH, OFFSET etc.
• Text Functions – LEN, FIND, LEFT, RIGHT, MID, TRIM etc.
• Database features – functions, reporting, filtering, extracting
• Pivot Tables
• Handling circular references

Now that you understand how to build a working model, this section completes your understanding by covering a wide variety of sensitivity and scenario analysis tools.

• Goal Seek
• Solver
• Scenarios
• Introduction to Macros (VBA)
• Introduction to User Defined Functions using VBA