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
I attended LEORON CFM course because the subjects they offered to cover was interesting to me since the type of my work require preparing valuation models, budgets and analysis using excel. I felt the difference from day one when they communicated with me, the support and care they showed was very encouraging to travel to attend the course, and then I was totally impressed in the materials, the instructor and the techniques he used in presenting the course. By the end of the course the attendances including myself were able to write a code using VBA, heavily using macros and many other financial functions that was first time to know and to get the vision of how useful it can be for me on my work. Today I’m doing the same tasks which I used to do but faster and fully automated and encouraging my team to attend the same course showing them the benefits of what I learned in 5 days. It was, with no doubt, the best trainings I attended during my career and would highly recommend this course to anyone who wants to improve his skills and financial knowledge. Thanks again for the great course”.
National Aviation Ground Support (NAGS)
The CFM course exceeded my expectations. The instructor, Mr. Hamed, utilized every minute in the course. He is a world-class trainer and made a complex subject very interesting and understandable. My learning curve in Macro & VBA accelerated sharply during the course. I would definitely recommend Mr. Hamed and LEORON for financial modeling courses.
Saudi Venture Capital Investment Company, KSA
I use Excel regularly, but the CFM training has exposed me to many more tools in excel, as well as skills in building dynamic models, and detailed financial analysis. This has been made possible by the in-depth knowledge and skills of Hamed, and his hands-on practical approach to the training."
“The course was great and added value to me in financial modeling through using multiple techniques in order to achieve the ultimate goal. Definitely I will be back again in the near future.”
Talal Faris Turki Al-Hathal
Senior Research Analyst
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
Facts & Numbers
International Associations and Institutes
Public sessions a year
training sectors we operate in
offices throughout the world
trained professionals in 2016