See other courses from London Training For Excellence
Jordan, Amman
Dates flexible
Professional Training Course
Yes (Details)
English
$4,000
Course Overview
Number crunching is one the most important aspects of any job in the world of finance. Unlike other businesses professionals in the finance industry have to work with large amounts of numbers. There is thus a need for people who have a good knowledge of MS Excel to create financial projections analyses competition and markets and make financial models. A mastery over Excel is actually a way to excel in the finance world as it ensures accuracy speed and can give you that edge over your peers. Our courses are aimed at both intermediate and experienced staff it is expected that all participants will have a good grasp of Excel prior to attending our courses.
Who should take this course
Accountants Finance Director Financial Analyst CFO Financial planner
Accreditation
CPD
Course content
Day 1:
- Financial Modelling Principles
- Excel as a tool for financial modelling
- Building financial models best practices
- Modelling growth drivers depreciation, cost drivers asset & debt schedules
Day 2:
- Valuation Principles
- Projecting cash flow statement
- Circular references and handling them
- Financial ratio analysis
- Valuation using DCF & Comps
- Scenario analysis and Building valuation dashboards
Day 3:
- Advanced Functions Tools & Charting Techniques
- Advanced Tools in Excel for Auditing Financial Models
- Mastering Financial Functions
- Advanced Charting Techniques in Excel
Day 4:
- Using Macros & VBA for Financial Modelling
- Understanding Macros & VBA for Financial Modelling
Day 5:
- Implementing Monte Carlo Simulation
- Advanced Charting Techniques in Excel Commodities
About Course Provider
London Training for Excellence offer a wide range of training courses in London for organisations and individuals who wish to advance their skills and knowledge in the business world. With a great training centre in London, London TFE have everything that is needed to understand the basic needs of a business. Each course focuses on the ‘real-life’ issues a business could face and how to tackle them with ease.
London TFE have a team of enthusiastic leaders and instructors who share a passion for education and want to deliver that same passion to every individual who wish to take a business to succession. Each training courses London encourages individual to aim high and reach their full potential.