F.M.M. Financial Modeling Master - Using Excel & VBA

Course Description

What Do Participants Learn?

Develop a thorough mastery of Excel and VBA software(s) for financial modeling purposes.

Learn the needed tools to build models that are less time and effort consuming

Learn the best practice in modeling forecast 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 macro

Who Should Attend?

All Excel Users particularly:

Financial Analyst

Chief Executive Officers

Chief Financial Officers

Portfolio managers

Corporate accountants

Credit analysts

Private equity managers

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

What Will the Learning Experience Include?

Phase: 1

Introduce

• Comprehensive pre-program activities include:
• Web-based information forms & surveys completed by attendee.
• Direct consultation with the attendee about the expectations.

• During the training, participants engage in data, activities, and conversations that lead to insight and knowledge.
• Participants learn from expert trainers who have both academic and business experiences.
• Highly applicable training content & instructive activities for adding depth to training topics.
• **A half-day site visit for integrating the experience & plan next steps. Opportunities to provide connections, ideas & support.

Phase: 2

Explore & Practice

Phase: 3

Apply

• Apply & sustain the learning experience by using this ongoing support:
• To ensure participant has new skills or behavior progress.
• Optional, fee-based mentoring & coaching with the trainer.
• Training materials & additional documents (e-books, pdf files, presentations and articles)

• Evaluate your training experience by giving us feedbacks and help us to reach our organizational goals.
• Participant's Evaluation
• Trainer's Evaluation

Phase: 4

EVALUATE