Financial Modeling Master - Advanced Diploma on Financial Modeling using Excel and VBA
LEORON Professional Development Institute
Course description
Financial Modeling Master
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.
Participants will need some basic knowledge of Excel but not of professional modelling or programming.
Download the course brochure!
Who should attend?
This course is for 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
Training content
Participants will explore the following topics:
- Design principles for good model building
- Exploring Excel functions
- Helpful starting hints
- The 40 functions you will work with as a financial modeler
- Financial functions
- Modeling forecasted financial statements
- Modeling Ratio Analysis and Key Performance Indicators
- Pivot Tables
- Power Pivot Extensions:
- Monte Carlo Simulation using Crystal Ball:
- Introduction to VBA
- Loops
- Building custom new functions in Excel using VBA
Certification / Credits
Some of the topics that will be discussed include:
- The 40 Excel functions that financial modellers use the most
- Best practice in modelling forecasted financial statements
(Balance Sheet, Income Statement and Cash Flow Statement) - Monte Carlo Simulation modelling
- The powerful combination of arrays, the offset function, the match function and drop down menus
- The danger of using IRR in isolation and possible solutions
- Modelling and automating ratio analysis in Excel
- Various Optimization solutions using Excel Solver (cash and inventory management, capacity planning and capital budgeting)
- Pivot Tables and OLAP tables.
- From the basics of VBA to building a loan amortization table using a VBA macro
- Coding a User Form in VBA to update your database automatically.
Why choose Leoron?
LEORON has worked with some of the largest companies in the World - but importantly we care about the individual. Through our Customer Happiness Team we ensure that everyone who attends a LEORON course has the support before, during and after to ensure their training needs are met.
We offer the highest level of training delivery, whether that be in our live-virtual training or in-classroom sessions, with our expert instructors guiding you through everything so that you’re left feeling assured and confident to utilize your new knowledge going forward.
About Leoron
LEORON Professional Development Institute
LEORON is the fastest growing global training institute in the World, having evolved over the past 11 years into a dominant training institute that offers a comprehensive set of training and development solutions to both individuals and businesses. Our locations...
Contact info
LEORON Professional Development Institute
No reviews available
Need help with your search?
findcourses.com offers a free consultancy service to help compare training for you and your team
