
This course is aimed at both intermediate and experienced staff and includes the construction of an integrated set of simplified financial statements and subsequent investment appraisal. You will learn key tools of Excel which are useful for business analysis and how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).
This course is aimed at both intermediate and experienced staff and includes the construction of an integrated set of simplified financial statements and subsequent investment appraisal. You will learn key tools of Excel which are useful for business analysis and how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).
For additional information please contact us
This course adopts a case study approach and minimizing the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.
The course is ideal for anyone looking to improve their skills in Excel. It will be of particular benefit to corporate and project financiers, finance managers, accountants and bankers.
By the end of this course, participants will understand :
- Improve their efficiency in using Excel shortcuts
- Use several of the support tools and techniques in spreadsheet programs
- Build a robust financial model
- How to forecast working capital using excel
- Analyse results from excel sheet based on financial statement input.
We have three discount options available, however please check with us directly for details as discounts are limited to certain cities.
- 5% early bird discount for registrations completed one month before session date
- 10% corporate discount for a minimum of 3 registrations : Contact us directly
- 15% discount for groups of 4 or more delegates
The discounts cannot be combined.
Financial modeling introduction
- Model benefits
- Model best practice
Basic financial modeling tools
- Excel overview and keyboard shortcuts
- Some relevant financial functions
- Some relevant created functions using VBA
- Some relevant logical functions
- Some relevant lookup functions
- Some relevant date and time functions
- Building charts
- Naming conventions, formatting conventions, organisation of spreadsheets and use of range names
- Using spinners for sensitivity analysis
- Using solver vs. goal seek
- Data validation and creating a drop down menu
- Sheet protection
- Hiding items, calculations, etc.…
- Hyperlinks
- Inserting notes
- Conditional formatting
Basic application models with basic Excel and VBA functions
- Investment decision criteria (FV, PV, NPV, IRR, MIRR, Payback, Discounted Payback, XIRR and XNPV)
- Breakeven and sensitivity analysis
- Differential analysis
- Mortgage
- Using macros
- Recording macros
- Creating functions using Visual Basic Applications (VBA®)
- Application examples using VBA®
There are no scheduled dates for this course. Fill out the form to check future dates or deliver the course in-house