Financial Modelling Master, Advanced Diploma in Financial Modelling Using Excel & VBA

Price: AED 4,170

Inquiry

FMM Financial Modeling Master program will provide you with the ability to create and understand financial models as 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.

London, United Kingdom

  • Price: EUR 4,170 - 4,770
  • Start Date: 20 Jul 2020
  • End Date: 24 Jul 2020
  • Duration: 4 days

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 delivered by Mr. Hamed Behairy 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. Delegates will need some basic knowledge of Excel but not of professional modeling or programming.

In addition to previous experience, delegates will have to also fulfill the following criteria:

  • Completion of the Competency Assessment Instrument
  • Attendance – delegates must attend all sessions of the course. Delegates who miss more than two hours of the course sessions will not be eligible to take the course exam
  • Successful completion of the course assessment (examination), home assignments and reaching the passing rate of 65%.
  • Diploma validity period: Once granted, this diploma is valid for a lifetime.

Course Key Takeaways

  • Develop a thorough mastery of excel and VBA software(s) for financial modelling purposes.
  • Learn the needed tools to build models that are less time and effort consuming
  • Learn the best practice in modelling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement)
  • Learn and Work with over 1 million rows of data in seconds with Power Pivot Data Mashup and Data Exploration
  • Learn the way how to get from the basics of VBA to building a loan amortization table using a VBA macrо

Who Should Attend?

All Excel Users particularly:

  • Financial Analyst
  • 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

Financial Modelling Master Diploma is Issued Through Ansi

Marking 100 years of experience, ANSI is the official U.S. representative to the International Organization for Standardization (ISO) and, via the U.S. National Committee, the International Electrotechnical Commission (IEC), and is a U.S. representative to the International Accreditation Forum (IAF). ANSI accreditation is nationally and internationally recognized as a mark of quality and assures that employers can have confidence that the certificate holder has completed the prescribed course of study. ANSI’s accreditation process itself follows ISO/IEC 17011, the International Standard that defines quality third-party accreditation practices. ANSI’s Certificate Accreditation Program (ANSI-CAP) accredits assessment–based education and training programs against the American National Standard ASTM E2659. The standard establishes guidelines for quality certificate program development and administration, and forms the foundation for a recognition system that enables consumers, employers, government agencies, and others to distinguish between qualified workers and those with less-than-quality credentials.

Oversight Committee Members
Tareq Naseriddin – Finance & Admin Manager at Barari Forest Management, UAE

A finance and management professional with 20+ years of exceptional track record in handling high and low end aspects of financial accounting and auditing, possessing allied exposure in administration, seeking a senior position with a dynamic organization to apply accrued skills in making tangible contributions to the overall financial bottom-line.

Community Rating

Studied or Worked here? Share Your Review

Please do not post:

  • Aggressive or discriminatory language
  • Profanities (of any kind)
  • Trade secrets or confidential information

Thank you once again for doing your part to keep Edarabia the most trusted education source.

Similar Courses to Advance Your Career

Strategic Budgeting & Financial Forecasting
Strategic Budgeting & Financial Forecasting
  • USD 4,250
Inquire
Real Estate Finance & Investment
Real Estate Finance & Investment
  • USD 4,250
Inquire
Islamic Investment Principles and Management
Islamic Investment Principles and Management
  • USD 4,250
Inquire
Sukuk Types - Structuring - Applications
Sukuk Types - Structuring - Applications
  • USD 4,250
Inquire
Principles of Microfinance
Principles of Microfinance
  • USD 4,250
Inquire
Basics of Banking
Basics of Banking
  • USD 4,250
Inquire