Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

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

By: LEORON Professional Development Institute

United Arab Emirates

05 - 09 Aug, 2018  5 days

Follow Event

  

USD 4,390

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, because 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 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 certification 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
Dubai Aug 05 - 09 Aug, 2018
USD 4,390.00 + 219.50 (VAT)
(Convert Currency)

+971 4 447 5711

Discounts available
Related Courses
Certified Asset Management Assessor Course Certified Asset Management Assessor Course
On going

5 days, 16 - 20 Dec, 2018 

2018-12-16 12:12:00
United Arab Emirates

LEORON Professional Development Institute

This highly interactive course is designed to provide an immersive training environment that maximizes the interaction between attendees and the instructor and the attendees with their ...

International Certificate in Advanced Leadership Skills Course International Certificate in Advanced Leadership Skills Course

4 days, 24 - 27 Dec, 2018 

2018-12-24 12:12:00
Spain

LEORON Professional Development Institute

Leadership is not something people are born with; leadership can be learned. All around the world businesses are realizing the power of great leadership. They realize the value it brings to the ...

Certificate in Physical Asset Management Course Certificate in Physical Asset Management Course
On going

5 days, 16 - 20 Dec, 2018 

2018-12-16 12:12:00
United Arab Emirates

LEORON Professional Development Institute

Physical Asset Management can reduce maintenance costs, increase the economic life of capital equipment, reduce company liability, increase the reliability of systems and components, and ...

Certificate in Leadership Thinking: Strategic, Future, Design, Systemic, Analytical, Innovation and Creative Thinking Certificate in Leadership Thinking: Strategic, Future, Design, Systemic, Analytical, Innovation and Creative Thinking
On going

5 days, 16 - 20 Dec, 2018 

2018-12-16 12:12:00
United Arab Emirates

LEORON Professional Development Institute

As the pace and nature of change increases globally, the complexity of solving problems is becoming a critical competency for leaders. The risk of flawed and short-term, knee-jerk decisions is, and ...