Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$4,500

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 analyse 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

Day5:

  • 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.