CFM Certified Financial Modeler - Advanced Financial Modelling Using Excel and VBA

Location
Saudi Arabia, Riyadh
Dates
24 - 28 Dec 2017 (5 days)
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$4,190

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 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 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, Regulators, Financial government, Officials, Strategic planners, Trustees, Compliance officers, Management consultants, Bank lending officers, Internal auditors, Management consultants, Corporate Finance lawyers

Eligibility

2+ years of experience | 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) and reaching the passing rate of 65%. Certificate validity period: Once granted, this certification is valid for a lifetime.

Accreditation

International Academy of Business and Finance Managers

Course content

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

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.