merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

How does COVID-19 impact education? See what we're doing to help our learners.

Financial Modelling Master - Advanced Diploma on Financial Modelling using Excel and VBA

LEORON Professional Development Institute
Course summary
5 days
3,490 - 4,770 USD excl. VAT
English
Open / Scheduled
Next available date: 20/07/2020 - London
Course Dates
London
20/07/2020   (English)
4,770 USD
Dubai
16/08/2020   (English)
4,770 USD
06/12/2020   (English)
4,770 USD
Khobar
30/08/2020   (English)
4,770 USD

Course Description

Financial Modelling Master

The ability to create and understand financial models is one of the most valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications. However, as a result of the so called ‘95/5’ rule it can be concluded that 95% of Excel users probably only use a mere 5% of the program’s power.

Most users know that they could be getting more out of Excel especially by using VBA which would result in them being able to build more flexible, dynamic and professional models. Unfortunately, this aspect of Excel and VBA often appears to be complex and intimidating.

This intensive 5 day workshop starts with basics and progresses in a logical step by step manner to the more complex and rewarding tools needed to build more robust models that save time, reduce unnecessary human errors and customize applications that would be impossible to achieve with sub-optimal models.

Every section is followed by a direct application related to the financial markets and financial issues. The course will emphasize some important financial concepts that will assist in building vigorous models. It is designed to give you the information you need without making you wade through cumbersome explanations and endless technical background.

Participants will need some basic knowledge of Excel but not of professional modelling or programming.

Download the course brochure!

Suitability - Who should attend?

This course is for all Excel users particularly:

  • Financial Analysts
  • Chief Executive Officers
  • Chief Financial Officers
  • Portfolio managers
  • Corporate accountants
  • Credit analysts
  • Private equity managers
  • Actuarist
  • Venture capitalists
  • Corporate finance analysts
  • Risk managers
  • Board members
  • Investment bankers
  • Regulators
  • Financial government officials
  • Strategic planners
  • Trustees
  • Compliance officers
  • Management consultants
  • Bank lending officers
  • Internal auditors
  • Management consultants
  • Corporate Finance lawyers

Outcome / Qualification etc.

Some of the topics that will be discussed include:

  • The 40 Excel functions that financial modellers use the most
  • Best practice in modelling forecasted financial statements
    (Balance Sheet, Income Statement and Cash Flow Statement)
  • Monte Carlo Simulation modelling
  • The powerful combination of arrays, the offset function, the match function and drop down menus
  • The danger of using IRR in isolation and possible solutions
  • Modelling and automating ratio analysis in Excel
  • Various Optimization solutions using Excel Solver (cash and inventory management, capacity planning and capital budgeting)
  • Pivot Tables and OLAP tables.
  • From the basics of VBA to building a loan amortization table using a VBA macro
  • Coding a User Form in VBA to update your database automatically.

Training Course Content

Participants will explore the following topics:

  • Design principles for good model building
  • Exploring Excel functions
  • Helpful starting hints
  • The 40 functions you will work with as a financial modeler
  • Financial functions
  • Modeling forecasted financial statements
  • Modeling Ratio Analysis and Key Performance Indicators
  • Pivot Tables
  • Power Pivot Extensions:
  • Monte Carlo Simulation using Crystal Ball:
  • Introduction to VBA
  • Loops
  • Building custom new functions in Excel using VBA

Get Inspired! Watch the Video

The Partners for Quality Award recognizes an Employer providing support to an individual where there was a significant benefit to the Division or Society. LEORON institute was granted the prestigious award for their continued promotion of Organizational Excellence through training courses that are directly related to quality improvement techniques and methodologies they provide while promoting the values and mission of ASQ Quality Management Division.

   

Provider: LEORON Professional Development Institute

LEORON-corporate-banner-findcourses

Built upon the strong experience in the manufacturing sector, which its founders developed in Sweden during the 90’s global expansion, LEORON evolved into the dominant training institute that offers a comprehensive set of training and development solutions. All across the...


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Financial Modelling Master - Advanced Diploma on Financial Modelling using Excel and VBA.

  Contact the provider

  Get more information

  Register your interest

Contact information for LEORON Professional Development Institute

LEORON Professional Development Institute

OFFICE 502, JLT
Dubai

 Show phone number
www.leoron.com


Reviews by course attendees

Average rating 5

Based on 3 reviews

Akmal B. D.
(5)
It was a privileged to attend Financial Modeling Master tutored by Hamed Behairy, CFA. For a long time, I’ve struggled to find a course that combines professional financial and Excel modeling skills. The course in all aspects is highly rated. I believe it’s worth much more than I paid and feel lucky to have taken your amazing course! I enjoyed h...
Show more
A. Al Jabr
(5)
Last week, we had an amazing Advanced Financial Modelling Course (FMM), organized by LEORON Institute. The course was delivered by Hamed Behairy, CFA. It was absolutely an eye-opener.. highly recommended for all finance & accounting professionals; definitely a must-have course. Outstanding trainer & delivery.
W. Alsmail
(5)
I just finished a course with Hamed Behairy, CFA in Financial Modeling. The course taught me about VBA, Macros and Monte Carlo Stimulation. Such course will help me to make my models more "Dynamic" rather than "Static", and my valuation to be more "probabilistic" rather than "deterministic". As for the instructor, Mr. Hamed is really a TALENT. ...
Show more
Request Information

Find out more about this Financial Modelling Master - Advanced Diploma on Financial Modelling using Excel and VBA course - simply fill out your details:

Reviews
Course rating
(5.0)
Based on 3 reviews
U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Be Inspired - watch the videos
   
Case Study
LEORON Accredited by ANSI

LEORON Institute is accredited by ANSI as, ANSI-Accredited Certificate Issuer.

Read more

Similar Courses