This course is part of the Financial Modelling Series:
For those new to Financial Modelling, this course will introduce the fundamentals and concepts of building a financial model using Excel. This is a practical course in which you will develop the skills to build your own financial model which can be taken away for future reference.
If no public workshops of this course are available in your area, consider taking the course online, or running it at your organisation inhouse.
Each participant on this course receives a hard copy of the book Using Excel for Business Analysis. Please let us know if you would prefer your copy in Kindle or other ebook format and we can send it to you in advance. Re-using your copy, got several participants or want to book on multiple courses? Consider making a bulk booking and save.
The course material includes use of Excel and participants will gain the maximum benefit from this course if they are already using spreadsheets. It is designed for users who do use (or will use) Excel on a semi-regular basis, and are comfortable with using its basic tools and functions. It is assumed that participants have either undertaken a basic Excel Introduction course, or else are able to:
• Navigate confidently in Excel
• Create and use simple formulas
• Link between workbooks
This course builds on students’ basic knowledge of simple formulas and incorporates these into a financial model.
Public courses are run in a computer laboratory with workstations provided. Participants may bring their own laptops if they prefer. The course is demonstrated using Microsoft Excel 2010, but students can use Excel 2003 or 2007 if they prefer. Course materials contain instructions for all versions, and Excel 2011 for Mac users are also catered for.
During the course, participants will create their own financial model to take away and use for future reference. You will learn how to design and create a user-friendly model which can then be taken away for future reference.
You will learn to:
- Select which formulas are appropriate in different situations
- Use absolute and relative cell referencing for modelling
- Identify common errors in modelling
- Use techniques to prevent model errors
- Document model assumptions
- Link and change variables
- Prevent data from being changed by protecting your model
- Build and use drop-down boxes
What is Financial Modelling?
- Overview of Financial Modelling
- Upgrading from Excel 2003 to 2007 or 2010
- Tool selection
- Purposes of financial models
- Selecting the correct formula
- Adjusting formulas manually
- Working with dates
- Applying absolute and relative cell referencing
- Modelling techniques to reduce potential for error
- Identifying common errors
- Building a simple error check formula
Building Financial Reports
- Review of Profit and Loss statements and Cashflow forecasts
- Why document assumptions?
- Linking to source referencing
Protecting your Model
- Using worksheet protection to prevent entry
- Restricting data entries using data validations
- Protecting your workbook using “Read Only” and password protection
- Hiding unnecessary information
- Using scenario manager
- Adjusting inputs variables to impact outcomes
- Presenting different scenarios in a table
Presenting the data
- Using charts to display data
- Creating a dynamic chart which changes according to variables
- Summarising model data into a presentation
Comments from past students
Thank you, I really enjoyed the introductory course on Financial Modelling; the course is well-structured and organised, and it delivers!
The course was exactly what I was looking for. It sets the fundamentals right for a robust financial model and teaches ways to go around building one. The speed and contents were just right for me and the online option was just great.... Will surely recommend this course.
Thanks for the course, I learnt a great deal!