Certified Financial Modeler - Advanced Financial Modeling Using Excel and VBA (In-House)

LEORON Professional Development Institute
Training overview
Corporate / Group Training
5 days
From 4,190 USD
Start dates
4,190 USD
Inquire for more information

Course description

Advanced Financial Modeling Using Excel and VBA - In-House

Creating and interpreting financial models is one of the most highly valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has been the premiere choice for finance and corporate professionals in the preparation and utilisation of the full range of financial models and other applications.

Most Excel users know that they could use more robust methods for getting the information they need. In particular, 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 highly interactive 5 day in-company workshop begins 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 customise 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.

Want to find out more?

Who should attend?

The in-house training course is suitable for:

  • Financial Analysts
  • 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
  • Corporate Finance lawyers

Training content


  • Design principles for good model building
  • Exploring Excel functions
  • Helpful starting hints
  • The 40 functions you will work with as a financial modeller


  • Financial functions
  • Modelling forecasted financial statements
  • Modeling Ratio Analysis and Key Performance Indicators


  • Optimization Solutions with Excel Solver
  • Pivot Tables
  • Power Pivot Extensions


  • Monte Carlo Simulation using Crystal Ball
  • Introduction to VBA
  • Case Study: Automating database update with new month data
  • Loops


  • Building custom new functions in Excel using VBA
  • Case study: Building a loan amortization table using VBA

Certification / Credits

Upon successful completion of this course, candidates will receive a Certificate of course completition with the Certified Financial Modeling (CFM™) title.

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

Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Certified Financial Modeler - Advanced Financial Modeling Using Excel and VBA (In-House).

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

LEORON Professional Development Institute


 Show phone number

Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available