Advanced Modeling with Excel and Visual Basic for Applications Course

Master advanced Excel and VBA skills for financial modeling with our specialized training course, tailored for finance professionals. BMC Training offers Advanced Modeling with Excel and Visual Basic for Applications Course in Finance , Accounting and Budgeting Courses.

  • English
  • 48 Training Sessions
  • Confirmed
  • One Week
Advanced Modeling with Excel and Visual Basic for Applications Training Course

Detailed description for visually impaired users: The image presents a view of Advanced Modeling with Excel and Visual Basic for Applications Training Course

Type a city name or a month
Venue Start Date End Date Net Fees Details & Registration
London , UK 22 - Nov - 2026 26 - Nov - 2026 4950 GBP
Madrid , Spain 22 - Nov - 2026 26 - Nov - 2026 6950 GBP
Munich , Germany 22 - Nov - 2026 26 - Nov - 2026 7900 GBP
Berlin , Germany 22 - Nov - 2026 26 - Nov - 2026 7900 GBP
New York , United States 22 - Nov - 2026 26 - Nov - 2026 10900 GBP
Amsterdam , Netherlands 22 - Nov - 2026 26 - Nov - 2026 8100 GBP
Milan , Italy 22 - Nov - 2026 26 - Nov - 2026 6950 GBP
Dubai , UAE 29 - Nov - 2026 3 - Dec - 2026 4987.5 GBP
Paris , France 29 - Nov - 2026 3 - Dec - 2026 6700 GBP
Hong Kong , Hong Kong 29 - Nov - 2026 3 - Dec - 2026 8500 GBP
Tokyo , Japan 29 - Nov - 2026 3 - Dec - 2026 9750 GBP
Geneva , Switzerland 29 - Nov - 2026 3 - Dec - 2026 8950 GBP
Istanbul , Turkey 6 - Dec - 2026 10 - Dec - 2026 4700 GBP
Bali , Indonesia 6 - Dec - 2026 10 - Dec - 2026 8100 GBP
Singapore , Singapore 6 - Dec - 2026 10 - Dec - 2026 7500 GBP
Washington , United States 6 - Dec - 2026 10 - Dec - 2026 11000 GBP
Dubai , UAE 13 - Dec - 2026 17 - Dec - 2026 4987.5 GBP
Paris , France 13 - Dec - 2026 17 - Dec - 2026 6700 GBP
Hong Kong , Hong Kong 13 - Dec - 2026 17 - Dec - 2026 8500 GBP
Tokyo , Japan 13 - Dec - 2026 17 - Dec - 2026 9750 GBP
Dubai , UAE 20 - Dec - 2026 24 - Dec - 2026 4987.5 GBP
Paris , France 20 - Dec - 2026 24 - Dec - 2026 6700 GBP
Hong Kong , Hong Kong 20 - Dec - 2026 24 - Dec - 2026 8500 GBP
Tokyo , Japan 20 - Dec - 2026 24 - Dec - 2026 9750 GBP
Kuala Lumpur , Malaysia 27 - Dec - 2026 31 - Dec - 2026 4750 GBP
Rome , Italy 27 - Dec - 2026 31 - Dec - 2026 7300 GBP
Barcelona , Spain 27 - Dec - 2026 31 - Dec - 2026 6950 GBP
Zurich , Switzerland 27 - Dec - 2026 31 - Dec - 2026 7950 GBP
Sydney , Australia 27 - Dec - 2026 31 - Dec - 2026 10900 GBP
London , UK 13 - Dec - 2026 17 - Dec - 2026 4950 GBP
Madrid , Spain 13 - Dec - 2026 17 - Dec - 2026 6950 GBP
Munich , Germany 13 - Dec - 2026 17 - Dec - 2026 7900 GBP
Berlin , Germany 13 - Dec - 2026 17 - Dec - 2026 7900 GBP
New York , United States 13 - Dec - 2026 17 - Dec - 2026 10900 GBP
Amsterdam , Netherlands 13 - Dec - 2026 17 - Dec - 2026 8100 GBP
Milan , Italy 13 - Dec - 2026 17 - Dec - 2026 6950 GBP
London , UK 20 - Dec - 2026 24 - Dec - 2026 4950 GBP
Madrid , Spain 20 - Dec - 2026 24 - Dec - 2026 6950 GBP
Munich , Germany 20 - Dec - 2026 24 - Dec - 2026 7900 GBP
Berlin , Germany 20 - Dec - 2026 24 - Dec - 2026 7900 GBP
New York , United States 20 - Dec - 2026 24 - Dec - 2026 10900 GBP
Amsterdam , Netherlands 20 - Dec - 2026 24 - Dec - 2026 8100 GBP
Milan , Italy 20 - Dec - 2026 24 - Dec - 2026 6950 GBP
Taipei , Taiwan 6 - Dec - 2026 10 - Dec - 2026 9300 GBP
Geneva , Switzerland 13 - Dec - 2026 17 - Dec - 2026 8950 GBP
Geneva , Switzerland 20 - Dec - 2026 24 - Dec - 2026 8950 GBP
Interlaken , Switzerland 27 - Dec - 2026 31 - Dec - 2026 8950 GBP
Los Angeles , USA 27 - Dec - 2026 31 - Dec - 2026 9500 GBP

Course Syllabus

Introduction:

Financial modeling is an essential skill for finance professionals and students. Excel VBA (Visual Basic for Application, the embedded programming language in Excel) allows you to create powerful spreadsheet models by overcoming the limitations of Excel and automating spreadsheet procedures . In this course, you will learn the fundamentals of Excel VBA and to apply it to developing financial models for various purposes. Upon completion of the course, you should be able to:

  • Understand Excel VBA and its application in finance
  • Design simple spreadsheet models for financial data analysis using Excel VBA

Course Content

Excel VBA Fundamentals

Participants will learn the fundamentals of Excel VBA and prepare themselves to create simple financial models in Part II. Small programs will be used to illustrate the underlying programming concepts.

  • The VBA programming environment
  • Variables and constants
  • Macros
  • Built-in VBA functions and operators
  • User-defined functions
  • Branching and looping
  • Object-based concept: Objects, methods and properties
  • The Range object
  • Debugging 
  • The following additional topics may also be covered if time allows:
  • Arrays
  • Procedures
  • Custom dialog boxes
  • Workbook and worksheet events
  • Chart objects

Financial Modeling

Participants will apply VBA programming concepts and skills to build simple yet real-world financial models. The techniques of writing good models will also be discussed. As the scope of financial modeling is huge, topics have to be selective. The following shows a list of possible topics. Actual coverage depends somewhat on the finance background of the class.

Loan amortization

  • Simple model 
  • Iteration: The bisection approach 
  • Allowance for changing interest rates or repayment period

Financial planning 

  • Retirement planning 
  • Portfolio restructuring

Market history analysis 

  • Normal and real growth of stocks 
  • Growth of investment in different assets

Stock simulation 

  • Stock volatility estimation 
  • The geometric Brownian motion and the log-normal distribution 
  • Stock price simulation

Option pricing 

  • Different option strategies 
  • The Black-Scholes option pricing model 
  • Implied volatility estimation 
  • Options portfolio 
  • The binomial models

Related Courses

FBA144

Effective Budgeting and Cost Control Course

Learn the essentials of effective budgeting and cost control to ensure your organization's financial stability with our course.
FBA121

Auditing in the Oil and Gas Industry Course

Master auditing practices tailored for the oil and gas industry with our specialized training course.
FBA183

Finance and Risk in Energy Markets Course

Explore finance principles and risk management strategies in energy markets to optimize investments, mitigate volatility, and drive informed decisions.
FBA136

Treasury and Cash Management Course

Gain invaluable insights into treasury and cash management to enhance organizational liquidity with our course.
FBA146

Chartered Financial Analyst - CFA Level 1 Preparation Course Course

Gear up for the CFA Level 1 exam with our preparation course designed to give you the knowledge and techniques needed.
FBA143

Certified Accounts Assistant Course

Become a certified accounts assistant and amplify your accounting skills for organizational success with our course.

Available Cities