FMM Financial Modelling Master - Advanced Diploma in Financial Modelling Using Excel and VBA

Location
UAE, Dubai
Dates
17 - 21 Mar 2019 (5 days)
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$4,390

Special prices available

Course Overview

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 suboptimal 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. Delegates will need some basic knowledge of Excel but not of professional modelling or programming.

Who should take this course

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

Accreditation

ANSI

Course content

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

About Course Provider

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.

Today, we are globally recognized as one of the leading educational providers of American and International certification programs.

LEORON’s courses are delivered by unrivaled global experts and facilitated by the best training managers in the industry. Our training programs offer a comprehensive suite of knowledge that is accredited by relevant industry institutions. Through powerful content, gamification and applied learning, our program offers a great way of building professional skills and competencies.

We offer training and development solutions in all strategic corporate functions, including corporate finance, HR, Supply Chain, operations, engineering and quality, etc. Our content-based programs are certified by leading institutes and academies, both on a local and global level.

We are locally accredited by KHDA and TVTC, whereas our list of global partners includes APICS, APMG International, AFP, IIA, ASQ, PMI, HRCI, IFMA, IABFM, CAIA, CISI, GARP, IACCM, ILM and many more.

HR Consultancy - we offer competency framework development, training needs analysis, capability and capacity building, strategic talent acquisition and much more. Our clients can gain more, whether they are facing difficulties re-organizing their brand, equipping their workforce with an extra set of skills or aiming to assess competencies within an existing structure.