Partners

Media

About Us

Contact

Certified Financial Modeler - Advanced Financial Modeling Using Excel and VBA

Dubai, UAE | December 11–15, 2016

Register
NOW!

This course is available as:

Public
On Site

Contact Person

Luljeta Sulja

+971 56 402 0355 UAE:+971 4 447 5711 ext.605 KSA: +966 11 464 4865 ext.605 luljeta.s@leoron.com
Course Overview

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

Delivery Type: Group Live | Prerequisites: None | Level: Advanced | This Program is worth: 35 NASBA CPE credits

Testimonials
Course key takeaways

1. Develop a thorough understanding of excel and vba software(s) for financial modelling purposes.
2. Learn the needed tools to build models that are less time and effort consuming
3. Gain the best practice in modelling forecasted financial statements
(Balance- Sheet, Income Statement and Cash Flow Statement)

4. Work with over 1 million rows of data in seconds with Power Pivot Data MAshup and Data Exploration
5. See the way how to get from the basics of VBA to building a loan amortization table using a VBA macro

LEORON Professional Development Institute

is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have nal authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org

Partners

Facts & Numbers

20+

International asociations & institutes

65

Consultancy projects in 2015

117

Companies we partnered with in 2015

48

Training need analysis projects in 2015

289

Public courses in 2016

80+

global matter experts

7

offices throughout the world

15+

training sectors we operate in

30+

Global cities

238

Delivered In-house programs in 2015

10000+

trained professionals in 2015