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
  • 214 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 28 - Apr - 2024 2 - May - 2024 4950 GBP
Madrid , Spain 28 - Apr - 2024 2 - May - 2024 6950 GBP
Munich , Germany 28 - Apr - 2024 2 - May - 2024 7900 GBP
Berlin , Germany 28 - Apr - 2024 2 - May - 2024 7900 GBP
New York , United States 28 - Apr - 2024 2 - May - 2024 10900 GBP
Amsterdam , Netherlands 28 - Apr - 2024 2 - May - 2024 8100 GBP
Istanbul , Turkey 12 - May - 2024 16 - May - 2024 4700 GBP
Bali , Indonesia 12 - May - 2024 16 - May - 2024 8100 GBP
Singapore , Singapore 12 - May - 2024 16 - May - 2024 7500 GBP
Dubai , UAE 5 - May - 2024 9 - May - 2024 4987.5 GBP
Paris , France 5 - May - 2024 9 - May - 2024 6700 GBP
Hong Kong , Hong Kong 5 - May - 2024 9 - May - 2024 8500 GBP
Dubai , UAE 19 - May - 2024 23 - May - 2024 4987.5 GBP
Paris , France 19 - May - 2024 23 - May - 2024 6700 GBP
Hong Kong , Hong Kong 19 - May - 2024 23 - May - 2024 8500 GBP
Kuala Lumpur , Malaysia 26 - May - 2024 30 - May - 2024 4750 GBP
Rome , Italy 26 - May - 2024 30 - May - 2024 7300 GBP
Barcelona , Spain 26 - May - 2024 30 - May - 2024 6950 GBP
Zurich , Switzerland 26 - May - 2024 30 - May - 2024 7950 GBP
London , UK 5 - May - 2024 9 - May - 2024 4950 GBP
Madrid , Spain 5 - May - 2024 9 - May - 2024 6950 GBP
Munich , Germany 5 - May - 2024 9 - May - 2024 7900 GBP
Berlin , Germany 5 - May - 2024 9 - May - 2024 7900 GBP
London , UK 19 - May - 2024 23 - May - 2024 4950 GBP
Madrid , Spain 19 - May - 2024 23 - May - 2024 6950 GBP
Munich , Germany 19 - May - 2024 23 - May - 2024 7900 GBP
Berlin , Germany 19 - May - 2024 23 - May - 2024 7900 GBP
Washington , United States 12 - May - 2024 16 - May - 2024 11000 GBP
New York , United States 5 - May - 2024 9 - May - 2024 10900 GBP
Amsterdam , Netherlands 5 - May - 2024 9 - May - 2024 8100 GBP
New York , United States 19 - May - 2024 23 - May - 2024 10900 GBP
Amsterdam , Netherlands 19 - May - 2024 23 - May - 2024 8100 GBP
London , UK 9 - Jun - 2024 13 - Jun - 2024 4950 GBP
Madrid , Spain 9 - Jun - 2024 13 - Jun - 2024 6950 GBP
Munich , Germany 9 - Jun - 2024 13 - Jun - 2024 7900 GBP
Berlin , Germany 9 - Jun - 2024 13 - Jun - 2024 7900 GBP
Dubai , UAE 16 - Jun - 2024 20 - Jun - 2024 4987.5 GBP
Paris , France 16 - Jun - 2024 20 - Jun - 2024 6700 GBP
Hong Kong , Hong Kong 16 - Jun - 2024 20 - Jun - 2024 8500 GBP
Istanbul , Turkey 23 - Jun - 2024 27 - Jun - 2024 4700 GBP
Bali , Indonesia 23 - Jun - 2024 27 - Jun - 2024 8100 GBP
Singapore , Singapore 23 - Jun - 2024 27 - Jun - 2024 7500 GBP
Kuala Lumpur , Malaysia 2 - Jun - 2024 6 - Jun - 2024 4750 GBP
Rome , Italy 2 - Jun - 2024 6 - Jun - 2024 7300 GBP
Barcelona , Spain 2 - Jun - 2024 6 - Jun - 2024 6950 GBP
Zurich , Switzerland 2 - Jun - 2024 6 - Jun - 2024 7950 GBP
Dubai , UAE 23 - Jun - 2024 27 - Jun - 2024 4987.5 GBP
Paris , France 23 - Jun - 2024 27 - Jun - 2024 6700 GBP
Hong Kong , Hong Kong 23 - Jun - 2024 27 - Jun - 2024 8500 GBP
London , UK 23 - Jun - 2024 27 - Jun - 2024 4950 GBP
Madrid , Spain 23 - Jun - 2024 27 - Jun - 2024 6950 GBP
Munich , Germany 23 - Jun - 2024 27 - Jun - 2024 7900 GBP
Berlin , Germany 23 - Jun - 2024 27 - Jun - 2024 7900 GBP
New York , United States 9 - Jun - 2024 13 - Jun - 2024 10900 GBP
Amsterdam , Netherlands 9 - Jun - 2024 13 - Jun - 2024 8100 GBP
Washington , United States 23 - Jun - 2024 27 - Jun - 2024 11000 GBP
New York , United States 23 - Jun - 2024 27 - Jun - 2024 10900 GBP
Amsterdam , Netherlands 23 - Jun - 2024 27 - Jun - 2024 8100 GBP
Istanbul , Turkey 7 - Jul - 2024 11 - Jul - 2024 4700 GBP
Bali , Indonesia 7 - Jul - 2024 11 - Jul - 2024 8100 GBP
Singapore , Singapore 7 - Jul - 2024 11 - Jul - 2024 7500 GBP
Dubai , UAE 14 - Jul - 2024 18 - Jul - 2024 4987.5 GBP
Paris , France 14 - Jul - 2024 18 - Jul - 2024 6700 GBP
Hong Kong , Hong Kong 14 - Jul - 2024 18 - Jul - 2024 8500 GBP
Dubai , UAE 21 - Jul - 2024 25 - Jul - 2024 4987.5 GBP
Paris , France 21 - Jul - 2024 25 - Jul - 2024 6700 GBP
Hong Kong , Hong Kong 21 - Jul - 2024 25 - Jul - 2024 8500 GBP
Kuala Lumpur , Malaysia 28 - Jul - 2024 1 - Aug - 2024 4750 GBP
Rome , Italy 28 - Jul - 2024 1 - Aug - 2024 7300 GBP
Barcelona , Spain 28 - Jul - 2024 1 - Aug - 2024 6950 GBP
Zurich , Switzerland 28 - Jul - 2024 1 - Aug - 2024 7950 GBP
London , UK 14 - Jul - 2024 18 - Jul - 2024 4950 GBP
Madrid , Spain 14 - Jul - 2024 18 - Jul - 2024 6950 GBP
Munich , Germany 14 - Jul - 2024 18 - Jul - 2024 7900 GBP
Berlin , Germany 14 - Jul - 2024 18 - Jul - 2024 7900 GBP
London , UK 21 - Jul - 2024 25 - Jul - 2024 4950 GBP
Madrid , Spain 21 - Jul - 2024 25 - Jul - 2024 6950 GBP
Munich , Germany 21 - Jul - 2024 25 - Jul - 2024 7900 GBP
Berlin , Germany 21 - Jul - 2024 25 - Jul - 2024 7900 GBP
Washington , United States 7 - Jul - 2024 11 - Jul - 2024 11000 GBP
New York , United States 14 - Jul - 2024 18 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 14 - Jul - 2024 18 - Jul - 2024 8100 GBP
New York , United States 21 - Jul - 2024 25 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 21 - Jul - 2024 25 - Jul - 2024 8100 GBP
London , UK 4 - Aug - 2024 8 - Aug - 2024 4950 GBP
Madrid , Spain 4 - Aug - 2024 8 - Aug - 2024 6950 GBP
Munich , Germany 4 - Aug - 2024 8 - Aug - 2024 7900 GBP
Berlin , Germany 4 - Aug - 2024 8 - Aug - 2024 7900 GBP
Dubai , UAE 11 - Aug - 2024 15 - Aug - 2024 4987.5 GBP
Paris , France 11 - Aug - 2024 15 - Aug - 2024 6700 GBP
Hong Kong , Hong Kong 11 - Aug - 2024 15 - Aug - 2024 8500 GBP
Istanbul , Turkey 18 - Aug - 2024 22 - Aug - 2024 4700 GBP
Bali , Indonesia 18 - Aug - 2024 22 - Aug - 2024 8100 GBP
Singapore , Singapore 18 - Aug - 2024 22 - Aug - 2024 7500 GBP
Kuala Lumpur , Malaysia 25 - Aug - 2024 29 - Aug - 2024 4750 GBP
Rome , Italy 25 - Aug - 2024 29 - Aug - 2024 7300 GBP
Barcelona , Spain 25 - Aug - 2024 29 - Aug - 2024 6950 GBP
Zurich , Switzerland 25 - Aug - 2024 29 - Aug - 2024 7950 GBP
Dubai , UAE 18 - Aug - 2024 22 - Aug - 2024 4987.5 GBP
Paris , France 18 - Aug - 2024 22 - Aug - 2024 6700 GBP
Hong Kong , Hong Kong 18 - Aug - 2024 22 - Aug - 2024 8500 GBP
London , UK 18 - Aug - 2024 22 - Aug - 2024 4950 GBP
Madrid , Spain 18 - Aug - 2024 22 - Aug - 2024 6950 GBP
Munich , Germany 18 - Aug - 2024 22 - Aug - 2024 7900 GBP
Berlin , Germany 18 - Aug - 2024 22 - Aug - 2024 7900 GBP
New York , United States 4 - Aug - 2024 8 - Aug - 2024 10900 GBP
Amsterdam , Netherlands 4 - Aug - 2024 8 - Aug - 2024 8100 GBP
Washington , United States 18 - Aug - 2024 22 - Aug - 2024 11000 GBP
New York , United States 18 - Aug - 2024 22 - Aug - 2024 10900 GBP
Amsterdam , Netherlands 18 - Aug - 2024 22 - Aug - 2024 8100 GBP
Istanbul , Turkey 22 - Sep - 2024 26 - Sep - 2024 4700 GBP
Bali , Indonesia 22 - Sep - 2024 26 - Sep - 2024 8100 GBP
Singapore , Singapore 22 - Sep - 2024 26 - Sep - 2024 7500 GBP
Dubai , UAE 1 - Sep - 2024 5 - Sep - 2024 4987.5 GBP
Paris , France 1 - Sep - 2024 5 - Sep - 2024 6700 GBP
Hong Kong , Hong Kong 1 - Sep - 2024 5 - Sep - 2024 8500 GBP
Dubai , UAE 8 - Sep - 2024 12 - Sep - 2024 4987.5 GBP
Paris , France 8 - Sep - 2024 12 - Sep - 2024 6700 GBP
Hong Kong , Hong Kong 8 - Sep - 2024 12 - Sep - 2024 8500 GBP
Kuala Lumpur , Malaysia 15 - Sep - 2024 19 - Sep - 2024 4750 GBP
Rome , Italy 15 - Sep - 2024 19 - Sep - 2024 7300 GBP
Barcelona , Spain 15 - Sep - 2024 19 - Sep - 2024 6950 GBP
Zurich , Switzerland 15 - Sep - 2024 19 - Sep - 2024 7950 GBP
London , UK 1 - Sep - 2024 5 - Sep - 2024 4950 GBP
Madrid , Spain 1 - Sep - 2024 5 - Sep - 2024 6950 GBP
Munich , Germany 1 - Sep - 2024 5 - Sep - 2024 7900 GBP
Berlin , Germany 1 - Sep - 2024 5 - Sep - 2024 7900 GBP
London , UK 8 - Sep - 2024 12 - Sep - 2024 4950 GBP
Madrid , Spain 8 - Sep - 2024 12 - Sep - 2024 6950 GBP
Munich , Germany 8 - Sep - 2024 12 - Sep - 2024 7900 GBP
Berlin , Germany 8 - Sep - 2024 12 - Sep - 2024 7900 GBP
Washington , United States 22 - Sep - 2024 26 - Sep - 2024 11000 GBP
New York , United States 1 - Sep - 2024 5 - Sep - 2024 10900 GBP
Amsterdam , Netherlands 1 - Sep - 2024 5 - Sep - 2024 8100 GBP
New York , United States 8 - Sep - 2024 12 - Sep - 2024 10900 GBP
Amsterdam , Netherlands 8 - Sep - 2024 12 - Sep - 2024 8100 GBP
London , UK 20 - Oct - 2024 24 - Oct - 2024 4950 GBP
Madrid , Spain 20 - Oct - 2024 24 - Oct - 2024 6950 GBP
Munich , Germany 20 - Oct - 2024 24 - Oct - 2024 7900 GBP
Berlin , Germany 20 - Oct - 2024 24 - Oct - 2024 7900 GBP
Dubai , UAE 27 - Oct - 2024 31 - Oct - 2024 4987.5 GBP
Paris , France 27 - Oct - 2024 31 - Oct - 2024 6700 GBP
Hong Kong , Hong Kong 27 - Oct - 2024 31 - Oct - 2024 8500 GBP
Istanbul , Turkey 6 - Oct - 2024 10 - Oct - 2024 4700 GBP
Bali , Indonesia 6 - Oct - 2024 10 - Oct - 2024 8100 GBP
Singapore , Singapore 6 - Oct - 2024 10 - Oct - 2024 7500 GBP
Kuala Lumpur , Malaysia 13 - Oct - 2024 17 - Oct - 2024 4750 GBP
Rome , Italy 13 - Oct - 2024 17 - Oct - 2024 7300 GBP
Barcelona , Spain 13 - Oct - 2024 17 - Oct - 2024 6950 GBP
Zurich , Switzerland 13 - Oct - 2024 17 - Oct - 2024 7950 GBP
Dubai , UAE 6 - Oct - 2024 10 - Oct - 2024 4987.5 GBP
Paris , France 6 - Oct - 2024 10 - Oct - 2024 6700 GBP
Hong Kong , Hong Kong 6 - Oct - 2024 10 - Oct - 2024 8500 GBP
London , UK 6 - Oct - 2024 10 - Oct - 2024 4950 GBP
Madrid , Spain 6 - Oct - 2024 10 - Oct - 2024 6950 GBP
Munich , Germany 6 - Oct - 2024 10 - Oct - 2024 7900 GBP
Berlin , Germany 6 - Oct - 2024 10 - Oct - 2024 7900 GBP
New York , United States 20 - Oct - 2024 24 - Oct - 2024 10900 GBP
Amsterdam , Netherlands 20 - Oct - 2024 24 - Oct - 2024 8100 GBP
Washington , United States 6 - Oct - 2024 10 - Oct - 2024 11000 GBP
New York , United States 6 - Oct - 2024 10 - Oct - 2024 10900 GBP
Amsterdam , Netherlands 6 - Oct - 2024 10 - Oct - 2024 8100 GBP
Istanbul , Turkey 17 - Nov - 2024 21 - Nov - 2024 4700 GBP
Bali , Indonesia 17 - Nov - 2024 21 - Nov - 2024 8100 GBP
Singapore , Singapore 17 - Nov - 2024 21 - Nov - 2024 7500 GBP
Dubai , UAE 24 - Nov - 2024 28 - Nov - 2024 4987.5 GBP
Paris , France 24 - Nov - 2024 28 - Nov - 2024 6700 GBP
Hong Kong , Hong Kong 24 - Nov - 2024 28 - Nov - 2024 8500 GBP
Dubai , UAE 3 - Nov - 2024 7 - Nov - 2024 4987.5 GBP
Paris , France 3 - Nov - 2024 7 - Nov - 2024 6700 GBP
Hong Kong , Hong Kong 3 - Nov - 2024 7 - Nov - 2024 8500 GBP
Kuala Lumpur , Malaysia 10 - Nov - 2024 14 - Nov - 2024 4750 GBP
Rome , Italy 10 - Nov - 2024 14 - Nov - 2024 7300 GBP
Barcelona , Spain 10 - Nov - 2024 14 - Nov - 2024 6950 GBP
Zurich , Switzerland 10 - Nov - 2024 14 - Nov - 2024 7950 GBP
London , UK 24 - Nov - 2024 28 - Nov - 2024 4950 GBP
Madrid , Spain 24 - Nov - 2024 28 - Nov - 2024 6950 GBP
Munich , Germany 24 - Nov - 2024 28 - Nov - 2024 7900 GBP
Berlin , Germany 24 - Nov - 2024 28 - Nov - 2024 7900 GBP
London , UK 3 - Nov - 2024 7 - Nov - 2024 4950 GBP
Madrid , Spain 3 - Nov - 2024 7 - Nov - 2024 6950 GBP
Munich , Germany 3 - Nov - 2024 7 - Nov - 2024 7900 GBP
Berlin , Germany 3 - Nov - 2024 7 - Nov - 2024 7900 GBP
Washington , United States 17 - Nov - 2024 21 - Nov - 2024 11000 GBP
New York , United States 24 - Nov - 2024 28 - Nov - 2024 10900 GBP
Amsterdam , Netherlands 24 - Nov - 2024 28 - Nov - 2024 8100 GBP
New York , United States 3 - Nov - 2024 7 - Nov - 2024 10900 GBP
Amsterdam , Netherlands 3 - Nov - 2024 7 - Nov - 2024 8100 GBP
London , UK 15 - Dec - 2024 19 - Dec - 2024 4950 GBP
Madrid , Spain 15 - Dec - 2024 19 - Dec - 2024 6950 GBP
Munich , Germany 15 - Dec - 2024 19 - Dec - 2024 7900 GBP
Berlin , Germany 15 - Dec - 2024 19 - Dec - 2024 7900 GBP
Dubai , UAE 22 - Dec - 2024 26 - Dec - 2024 4987.5 GBP
Paris , France 22 - Dec - 2024 26 - Dec - 2024 6700 GBP
Hong Kong , Hong Kong 22 - Dec - 2024 26 - Dec - 2024 8500 GBP
Istanbul , Turkey 8 - Dec - 2024 12 - Dec - 2024 4700 GBP
Bali , Indonesia 8 - Dec - 2024 12 - Dec - 2024 8100 GBP
Singapore , Singapore 8 - Dec - 2024 12 - Dec - 2024 7500 GBP
Kuala Lumpur , Malaysia 1 - Dec - 2024 5 - Dec - 2024 4750 GBP
Rome , Italy 1 - Dec - 2024 5 - Dec - 2024 7300 GBP
Barcelona , Spain 1 - Dec - 2024 5 - Dec - 2024 6950 GBP
Zurich , Switzerland 1 - Dec - 2024 5 - Dec - 2024 7950 GBP
Dubai , UAE 8 - Dec - 2024 12 - Dec - 2024 4987.5 GBP
Paris , France 8 - Dec - 2024 12 - Dec - 2024 6700 GBP
Hong Kong , Hong Kong 8 - Dec - 2024 12 - Dec - 2024 8500 GBP
London , UK 8 - Dec - 2024 12 - Dec - 2024 4950 GBP
Madrid , Spain 8 - Dec - 2024 12 - Dec - 2024 6950 GBP
Munich , Germany 8 - Dec - 2024 12 - Dec - 2024 7900 GBP
Berlin , Germany 8 - Dec - 2024 12 - Dec - 2024 7900 GBP
New York , United States 15 - Dec - 2024 19 - Dec - 2024 10900 GBP
Amsterdam , Netherlands 15 - Dec - 2024 19 - Dec - 2024 8100 GBP
Washington , United States 8 - Dec - 2024 12 - Dec - 2024 11000 GBP
New York , United States 8 - Dec - 2024 12 - Dec - 2024 10900 GBP
Amsterdam , Netherlands 8 - Dec - 2024 12 - Dec - 2024 8100 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

FBA143

Certified Accounts Assistant Course

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

Effective Budgeting and Operational Cost Control Course

Learn effective budgeting and operational cost control methods with our specialized training course, ideal for managers.
FBA148

Financial Statements Consolidation and Investment Accounting Course

Master the complexities of financial statements consolidation and investment accounting with our specialized 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.
FBA149

Preparing Financial Statements and the Annual Report Course

Equip yourself with the skills needed to prepare financial statements and annual reports accurately and efficiently.
FBA173

Financial Analysis and Investigation Course

Acquire skills in financial analysis and investigation in this training course. Learn techniques for evaluating financial data and making informed decisions.

Available Cities