Course Overview
This intermediate – advanced level course will focus on the tools and techniques available in Microsoft Excel to enable you to develop, run and review financial models across multiple scenarios. You will gain a sound and practical insight into forecasting financial statements for five and ten year periods.
Throughout this course, you are encouraged to work on and develop solutions to your own work based financial modelling challenges,
• Discover how to save more time and work even faster with a financial model
• How to automate tasks and processes
• Gain frameworks to know with confidence your models are reliable and robust
• Extend the breadth of your financial modelling expertise by ensuring you are up to date with the latest thinking in Excel, modelling and forecasting
Course Objective
By the end of this course, you will be able to:
● Analyse financial statements using modelling
● Create scenarios
● Develop a model for investment decision
● Create a sensitivity analysis model
● Use more advanced Excel functions that will allow faster model development and provide greater reliability.
● Employ sophisticated methods of data analysis and visualisation that present information easily or highlight anomalies and areas of interest
● Review techniques for working with time series in models that allow automated data generation and summarisation at any level
● Use best practice guidelines and spreadsheet modelling standards: learn how to create models like the professionals do!
● Apply advanced techniques for sophisticated model optimisation
● Apply the new features of Excel to increase advanced financial modelling productivity: for example, dynamic array functions
Imagine yourself blazing through a financial model using functions that most normal people are completely unaware of. You will gain the satisfaction of knowing you are the specialist in Financial Modelling and Financial Statement Forecasting using Excel in your own organisation.
Who should Attend ?
● Financial directors and managers
● Financial controllers
● Risk managers
● Credit manages
● Financial and management accountants
● Financial project administrators
● Project finance professionals
● Financial planners
● Anyone responsible for or involved in financial modelling
Contact us for further information
Write to Us:
training@leadecisions.com