Advanced Modeling with Excel and Visual Basic for Applications

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

  • English
  • 298 Training Sessions
  • Confirmed
  • One Week
  • Course Schedule
  • Courses Syllabus
  • Related Courses
  • Available Cities
Venue Start Date End Date Net Fees Details & Registration
Istanbul, Turkey26 - Jan - 202530 - Jan - 20254700 GBPPDF Register
Bali, Indonesia26 - Jan - 202530 - Jan - 20258100 GBPPDF Register
Singapore, Singapore26 - Jan - 202530 - Jan - 20257500 GBPPDF Register
Washington, United States26 - Jan - 202530 - Jan - 202511000 GBPPDF Register
Taipei, Taiwan26 - Jan - 202530 - Jan - 20259300 GBPPDF Register
London, UK23 - Feb - 202527 - Feb - 20254950 GBPPDF Register
Madrid, Spain23 - Feb - 202527 - Feb - 20256950 GBPPDF Register
Munich, Germany23 - Feb - 202527 - Feb - 20257900 GBPPDF Register
Berlin, Germany23 - Feb - 202527 - Feb - 20257900 GBPPDF Register
New York, United States23 - Feb - 202527 - Feb - 202510900 GBPPDF Register
Amsterdam, Netherlands23 - Feb - 202527 - Feb - 20258100 GBPPDF Register
Milan, Italy23 - Feb - 202527 - Feb - 20256950 GBPPDF Register
Dubai, UAE16 - Feb - 202520 - Feb - 20254987.5 GBPPDF Register
Paris, France16 - Feb - 202520 - Feb - 20256700 GBPPDF Register
Hong Kong, Hong Kong16 - Feb - 202520 - Feb - 20258500 GBPPDF Register
Tokyo, Japan16 - Feb - 202520 - Feb - 20259750 GBPPDF Register
Istanbul, Turkey09 - Feb - 202513 - Feb - 20254700 GBPPDF Register
Bali, Indonesia09 - Feb - 202513 - Feb - 20258100 GBPPDF Register
Singapore, Singapore09 - Feb - 202513 - Feb - 20257500 GBPPDF Register
Washington, United States09 - Feb - 202513 - Feb - 202511000 GBPPDF Register
Kuala Lumpur, Malaysia02 - Feb - 202506 - Feb - 20254750 GBPPDF Register
Rome, Italy02 - Feb - 202506 - Feb - 20257300 GBPPDF Register
Barcelona, Spain02 - Feb - 202506 - Feb - 20256950 GBPPDF Register
Zurich, Switzerland02 - Feb - 202506 - Feb - 20257950 GBPPDF Register
Dubai, UAE09 - Feb - 202513 - Feb - 20254987.5 GBPPDF Register
Paris, France09 - Feb - 202513 - Feb - 20256700 GBPPDF Register
Hong Kong, Hong Kong09 - Feb - 202513 - Feb - 20258500 GBPPDF Register
Tokyo, Japan09 - Feb - 202513 - Feb - 20259750 GBPPDF Register
London, UK09 - Feb - 202513 - Feb - 20254950 GBPPDF Register
Madrid, Spain09 - Feb - 202513 - Feb - 20256950 GBPPDF Register
Munich, Germany09 - Feb - 202513 - Feb - 20257900 GBPPDF Register
Berlin, Germany09 - Feb - 202513 - Feb - 20257900 GBPPDF Register
New York, United States09 - Feb - 202513 - Feb - 202510900 GBPPDF Register
Amsterdam, Netherlands09 - Feb - 202513 - Feb - 20258100 GBPPDF Register
Milan, Italy09 - Feb - 202513 - Feb - 20256950 GBPPDF Register
Taipei, Taiwan09 - Feb - 202513 - Feb - 20259300 GBPPDF Register
Sydney, Australia02 - Feb - 202506 - Feb - 202510900 GBPPDF Register
Interlaken, Switzerland02 - Feb - 202506 - Feb - 20258950 GBPPDF Register
Istanbul, Turkey16 - Mar - 202520 - Mar - 20254700 GBPPDF Register
Bali, Indonesia16 - Mar - 202520 - Mar - 20258100 GBPPDF Register
Singapore, Singapore16 - Mar - 202520 - Mar - 20257500 GBPPDF Register
Washington, United States16 - Mar - 202520 - Mar - 202511000 GBPPDF Register
Dubai, UAE09 - Mar - 202513 - Mar - 20254987.5 GBPPDF Register
Paris, France09 - Mar - 202513 - Mar - 20256700 GBPPDF Register
Hong Kong, Hong Kong09 - Mar - 202513 - Mar - 20258500 GBPPDF Register
Tokyo, Japan09 - Mar - 202513 - Mar - 20259750 GBPPDF Register
Dubai, UAE02 - Mar - 202506 - Mar - 20254987.5 GBPPDF Register
Paris, France02 - Mar - 202506 - Mar - 20256700 GBPPDF Register
Hong Kong, Hong Kong02 - Mar - 202506 - Mar - 20258500 GBPPDF Register
Tokyo, Japan02 - Mar - 202506 - Mar - 20259750 GBPPDF Register
Kuala Lumpur, Malaysia23 - Mar - 202527 - Mar - 20254750 GBPPDF Register
Rome, Italy23 - Mar - 202527 - Mar - 20257300 GBPPDF Register
Barcelona, Spain23 - Mar - 202527 - Mar - 20256950 GBPPDF Register
Zurich, Switzerland23 - Mar - 202527 - Mar - 20257950 GBPPDF Register
London, UK09 - Mar - 202513 - Mar - 20254950 GBPPDF Register
Madrid, Spain09 - Mar - 202513 - Mar - 20256950 GBPPDF Register
Munich, Germany09 - Mar - 202513 - Mar - 20257900 GBPPDF Register
Berlin, Germany09 - Mar - 202513 - Mar - 20257900 GBPPDF Register
New York, United States09 - Mar - 202513 - Mar - 202510900 GBPPDF Register
Amsterdam, Netherlands09 - Mar - 202513 - Mar - 20258100 GBPPDF Register
Milan, Italy09 - Mar - 202513 - Mar - 20256950 GBPPDF Register
London, UK02 - Mar - 202506 - Mar - 20254950 GBPPDF Register
Madrid, Spain02 - Mar - 202506 - Mar - 20256950 GBPPDF Register
Munich, Germany02 - Mar - 202506 - Mar - 20257900 GBPPDF Register
Berlin, Germany02 - Mar - 202506 - Mar - 20257900 GBPPDF Register
New York, United States02 - Mar - 202506 - Mar - 202510900 GBPPDF Register
Amsterdam, Netherlands02 - Mar - 202506 - Mar - 20258100 GBPPDF Register
Milan, Italy02 - Mar - 202506 - Mar - 20256950 GBPPDF Register
Taipei, Taiwan16 - Mar - 202520 - Mar - 20259300 GBPPDF Register
Sydney, Australia23 - Mar - 202527 - Mar - 202510900 GBPPDF Register
Interlaken, Switzerland23 - Mar - 202527 - Mar - 20258950 GBPPDF Register
London, UK27 - Apr - 202501 - May - 20254950 GBPPDF Register
Madrid, Spain27 - Apr - 202501 - May - 20256950 GBPPDF Register
Munich, Germany27 - Apr - 202501 - May - 20257900 GBPPDF Register
Berlin, Germany27 - Apr - 202501 - May - 20257900 GBPPDF Register
New York, United States27 - Apr - 202501 - May - 202510900 GBPPDF Register
Amsterdam, Netherlands27 - Apr - 202501 - May - 20258100 GBPPDF Register
Milan, Italy27 - Apr - 202501 - May - 20256950 GBPPDF Register
Dubai, UAE06 - Apr - 202510 - Apr - 20254987.5 GBPPDF Register
Paris, France06 - Apr - 202510 - Apr - 20256700 GBPPDF Register
Hong Kong, Hong Kong06 - Apr - 202510 - Apr - 20258500 GBPPDF Register
Tokyo, Japan06 - Apr - 202510 - Apr - 20259750 GBPPDF Register
Istanbul, Turkey13 - Apr - 202517 - Apr - 20254700 GBPPDF Register
Bali, Indonesia13 - Apr - 202517 - Apr - 20258100 GBPPDF Register
Singapore, Singapore13 - Apr - 202517 - Apr - 20257500 GBPPDF Register
Washington, United States13 - Apr - 202517 - Apr - 202511000 GBPPDF Register
Kuala Lumpur, Malaysia20 - Apr - 202524 - Apr - 20254750 GBPPDF Register
Rome, Italy20 - Apr - 202524 - Apr - 20257300 GBPPDF Register
Barcelona, Spain20 - Apr - 202524 - Apr - 20256950 GBPPDF Register
Zurich, Switzerland20 - Apr - 202524 - Apr - 20257950 GBPPDF Register
Dubai, UAE13 - Apr - 202517 - Apr - 20254987.5 GBPPDF Register
Paris, France13 - Apr - 202517 - Apr - 20256700 GBPPDF Register
Hong Kong, Hong Kong13 - Apr - 202517 - Apr - 20258500 GBPPDF Register
Tokyo, Japan13 - Apr - 202517 - Apr - 20259750 GBPPDF Register
London, UK13 - Apr - 202517 - Apr - 20254950 GBPPDF Register
Madrid, Spain13 - Apr - 202517 - Apr - 20256950 GBPPDF Register
Munich, Germany13 - Apr - 202517 - Apr - 20257900 GBPPDF Register
Berlin, Germany13 - Apr - 202517 - Apr - 20257900 GBPPDF Register
New York, United States13 - Apr - 202517 - Apr - 202510900 GBPPDF Register
Amsterdam, Netherlands13 - Apr - 202517 - Apr - 20258100 GBPPDF Register
Milan, Italy13 - Apr - 202517 - Apr - 20256950 GBPPDF Register
Taipei, Taiwan13 - Apr - 202517 - Apr - 20259300 GBPPDF Register
Sydney, Australia20 - Apr - 202524 - Apr - 202510900 GBPPDF Register
Interlaken, Switzerland20 - Apr - 202524 - Apr - 20258950 GBPPDF Register
Istanbul, Turkey11 - May - 202515 - May - 20254700 GBPPDF Register
Bali, Indonesia11 - May - 202515 - May - 20258100 GBPPDF Register
Singapore, Singapore11 - May - 202515 - May - 20257500 GBPPDF Register
Washington, United States11 - May - 202515 - May - 202511000 GBPPDF Register
Dubai, UAE04 - May - 202508 - May - 20254987.5 GBPPDF Register
Paris, France04 - May - 202508 - May - 20256700 GBPPDF Register
Hong Kong, Hong Kong04 - May - 202508 - May - 20258500 GBPPDF Register
Tokyo, Japan04 - May - 202508 - May - 20259750 GBPPDF Register
Dubai, UAE18 - May - 202522 - May - 20254987.5 GBPPDF Register
Paris, France18 - May - 202522 - May - 20256700 GBPPDF Register
Hong Kong, Hong Kong18 - May - 202522 - May - 20258500 GBPPDF Register
Tokyo, Japan18 - May - 202522 - May - 20259750 GBPPDF Register
Kuala Lumpur, Malaysia25 - May - 202529 - May - 20254750 GBPPDF Register
Rome, Italy25 - May - 202529 - May - 20257300 GBPPDF Register
Barcelona, Spain25 - May - 202529 - May - 20256950 GBPPDF Register
Zurich, Switzerland25 - May - 202529 - May - 20257950 GBPPDF Register
London, UK04 - May - 202508 - May - 20254950 GBPPDF Register
Madrid, Spain04 - May - 202508 - May - 20256950 GBPPDF Register
Munich, Germany04 - May - 202508 - May - 20257900 GBPPDF Register
Berlin, Germany04 - May - 202508 - May - 20257900 GBPPDF Register
New York, United States04 - May - 202508 - May - 202510900 GBPPDF Register
Amsterdam, Netherlands04 - May - 202508 - May - 20258100 GBPPDF Register
Milan, Italy04 - May - 202508 - May - 20256950 GBPPDF Register
London, UK18 - May - 202522 - May - 20254950 GBPPDF Register
Madrid, Spain18 - May - 202522 - May - 20256950 GBPPDF Register
Munich, Germany18 - May - 202522 - May - 20257900 GBPPDF Register
Berlin, Germany18 - May - 202522 - May - 20257900 GBPPDF Register
New York, United States18 - May - 202522 - May - 202510900 GBPPDF Register
Amsterdam, Netherlands18 - May - 202522 - May - 20258100 GBPPDF Register
Milan, Italy18 - May - 202522 - May - 20256950 GBPPDF Register
Taipei, Taiwan11 - May - 202515 - May - 20259300 GBPPDF Register
Sydney, Australia25 - May - 202529 - May - 202510900 GBPPDF Register
Interlaken, Switzerland25 - May - 202529 - May - 20258950 GBPPDF Register
London, UK08 - Jun - 202512 - Jun - 20254950 GBPPDF Register
Madrid, Spain08 - Jun - 202512 - Jun - 20256950 GBPPDF Register
Munich, Germany08 - Jun - 202512 - Jun - 20257900 GBPPDF Register
Berlin, Germany08 - Jun - 202512 - Jun - 20257900 GBPPDF Register
New York, United States08 - Jun - 202512 - Jun - 202510900 GBPPDF Register
Amsterdam, Netherlands08 - Jun - 202512 - Jun - 20258100 GBPPDF Register
Milan, Italy08 - Jun - 202512 - Jun - 20256950 GBPPDF Register
Dubai, UAE15 - Jun - 202519 - Jun - 20254987.5 GBPPDF Register
Paris, France15 - Jun - 202519 - Jun - 20256700 GBPPDF Register
Hong Kong, Hong Kong15 - Jun - 202519 - Jun - 20258500 GBPPDF Register
Tokyo, Japan15 - Jun - 202519 - Jun - 20259750 GBPPDF Register
Istanbul, Turkey22 - Jun - 202526 - Jun - 20254700 GBPPDF Register
Bali, Indonesia22 - Jun - 202526 - Jun - 20258100 GBPPDF Register
Singapore, Singapore22 - Jun - 202526 - Jun - 20257500 GBPPDF Register
Washington, United States22 - Jun - 202526 - Jun - 202511000 GBPPDF Register
Kuala Lumpur, Malaysia01 - Jun - 202505 - Jun - 20254750 GBPPDF Register
Rome, Italy01 - Jun - 202505 - Jun - 20257300 GBPPDF Register
Barcelona, Spain01 - Jun - 202505 - Jun - 20256950 GBPPDF Register
Zurich, Switzerland01 - Jun - 202505 - Jun - 20257950 GBPPDF Register
Dubai, UAE22 - Jun - 202526 - Jun - 20254987.5 GBPPDF Register
Paris, France22 - Jun - 202526 - Jun - 20256700 GBPPDF Register
Hong Kong, Hong Kong22 - Jun - 202526 - Jun - 20258500 GBPPDF Register
Tokyo, Japan22 - Jun - 202526 - Jun - 20259750 GBPPDF Register
London, UK22 - Jun - 202526 - Jun - 20254950 GBPPDF Register
Madrid, Spain22 - Jun - 202526 - Jun - 20256950 GBPPDF Register
Munich, Germany22 - Jun - 202526 - Jun - 20257900 GBPPDF Register
Berlin, Germany22 - Jun - 202526 - Jun - 20257900 GBPPDF Register
New York, United States22 - Jun - 202526 - Jun - 202510900 GBPPDF Register
Amsterdam, Netherlands22 - Jun - 202526 - Jun - 20258100 GBPPDF Register
Milan, Italy22 - Jun - 202526 - Jun - 20256950 GBPPDF Register
Taipei, Taiwan22 - Jun - 202526 - Jun - 20259300 GBPPDF Register
Sydney, Australia01 - Jun - 202505 - Jun - 202510900 GBPPDF Register
Interlaken, Switzerland01 - Jun - 202505 - Jun - 20258950 GBPPDF Register
Istanbul, Turkey06 - Jul - 202510 - Jul - 20254700 GBPPDF Register
Bali, Indonesia06 - Jul - 202510 - Jul - 20258100 GBPPDF Register
Singapore, Singapore06 - Jul - 202510 - Jul - 20257500 GBPPDF Register
Washington, United States06 - Jul - 202510 - Jul - 202511000 GBPPDF Register
Dubai, UAE13 - Jul - 202517 - Jul - 20254987.5 GBPPDF Register
Paris, France13 - Jul - 202517 - Jul - 20256700 GBPPDF Register
Hong Kong, Hong Kong13 - Jul - 202517 - Jul - 20258500 GBPPDF Register
Tokyo, Japan13 - Jul - 202517 - Jul - 20259750 GBPPDF Register
Dubai, UAE20 - Jul - 202524 - Jul - 20254987.5 GBPPDF Register
Paris, France20 - Jul - 202524 - Jul - 20256700 GBPPDF Register
Hong Kong, Hong Kong20 - Jul - 202524 - Jul - 20258500 GBPPDF Register
Tokyo, Japan20 - Jul - 202524 - Jul - 20259750 GBPPDF Register
Kuala Lumpur, Malaysia27 - Jul - 202531 - Jul - 20254750 GBPPDF Register
Rome, Italy27 - Jul - 202531 - Jul - 20257300 GBPPDF Register
Barcelona, Spain27 - Jul - 202531 - Jul - 20256950 GBPPDF Register
Zurich, Switzerland27 - Jul - 202531 - Jul - 20257950 GBPPDF Register
London, UK13 - Jul - 202517 - Jul - 20254950 GBPPDF Register
Madrid, Spain13 - Jul - 202517 - Jul - 20256950 GBPPDF Register
Munich, Germany13 - Jul - 202517 - Jul - 20257900 GBPPDF Register
Berlin, Germany13 - Jul - 202517 - Jul - 20257900 GBPPDF Register
New York, United States13 - Jul - 202517 - Jul - 202510900 GBPPDF Register
Amsterdam, Netherlands13 - Jul - 202517 - Jul - 20258100 GBPPDF Register
Milan, Italy13 - Jul - 202517 - Jul - 20256950 GBPPDF Register
London, UK20 - Jul - 202524 - Jul - 20254950 GBPPDF Register
Madrid, Spain20 - Jul - 202524 - Jul - 20256950 GBPPDF Register
Munich, Germany20 - Jul - 202524 - Jul - 20257900 GBPPDF Register
Berlin, Germany20 - Jul - 202524 - Jul - 20257900 GBPPDF Register
New York, United States20 - Jul - 202524 - Jul - 202510900 GBPPDF Register
Amsterdam, Netherlands20 - Jul - 202524 - Jul - 20258100 GBPPDF Register
Milan, Italy20 - Jul - 202524 - Jul - 20256950 GBPPDF Register
Taipei, Taiwan06 - Jul - 202510 - Jul - 20259300 GBPPDF Register
Sydney, Australia27 - Jul - 202531 - Jul - 202510900 GBPPDF Register
Interlaken, Switzerland27 - Jul - 202531 - Jul - 20258950 GBPPDF Register
London, UK03 - Aug - 202507 - Aug - 20254950 GBPPDF Register
Madrid, Spain03 - Aug - 202507 - Aug - 20256950 GBPPDF Register
Munich, Germany03 - Aug - 202507 - Aug - 20257900 GBPPDF Register
Berlin, Germany03 - Aug - 202507 - Aug - 20257900 GBPPDF Register
New York, United States03 - Aug - 202507 - Aug - 202510900 GBPPDF Register
Amsterdam, Netherlands03 - Aug - 202507 - Aug - 20258100 GBPPDF Register
Milan, Italy03 - Aug - 202507 - Aug - 20256950 GBPPDF Register
Dubai, UAE10 - Aug - 202514 - Aug - 20254987.5 GBPPDF Register
Paris, France10 - Aug - 202514 - Aug - 20256700 GBPPDF Register
Hong Kong, Hong Kong10 - Aug - 202514 - Aug - 20258500 GBPPDF Register
Tokyo, Japan10 - Aug - 202514 - Aug - 20259750 GBPPDF Register
Istanbul, Turkey17 - Aug - 202521 - Aug - 20254700 GBPPDF Register
Bali, Indonesia17 - Aug - 202521 - Aug - 20258100 GBPPDF Register
Singapore, Singapore17 - Aug - 202521 - Aug - 20257500 GBPPDF Register
Washington, United States17 - Aug - 202521 - Aug - 202511000 GBPPDF Register
Kuala Lumpur, Malaysia24 - Aug - 202528 - Aug - 20254750 GBPPDF Register
Rome, Italy24 - Aug - 202528 - Aug - 20257300 GBPPDF Register
Barcelona, Spain24 - Aug - 202528 - Aug - 20256950 GBPPDF Register
Zurich, Switzerland24 - Aug - 202528 - Aug - 20257950 GBPPDF Register
Dubai, UAE17 - Aug - 202521 - Aug - 20254987.5 GBPPDF Register
Paris, France17 - Aug - 202521 - Aug - 20256700 GBPPDF Register
Hong Kong, Hong Kong17 - Aug - 202521 - Aug - 20258500 GBPPDF Register
Tokyo, Japan17 - Aug - 202521 - Aug - 20259750 GBPPDF Register
London, UK17 - Aug - 202521 - Aug - 20254950 GBPPDF Register
Madrid, Spain17 - Aug - 202521 - Aug - 20256950 GBPPDF Register
Munich, Germany17 - Aug - 202521 - Aug - 20257900 GBPPDF Register
Berlin, Germany17 - Aug - 202521 - Aug - 20257900 GBPPDF Register
New York, United States17 - Aug - 202521 - Aug - 202510900 GBPPDF Register
Amsterdam, Netherlands17 - Aug - 202521 - Aug - 20258100 GBPPDF Register
Milan, Italy17 - Aug - 202521 - Aug - 20256950 GBPPDF Register
Taipei, Taiwan17 - Aug - 202521 - Aug - 20259300 GBPPDF Register
Sydney, Australia24 - Aug - 202528 - Aug - 202510900 GBPPDF Register
Interlaken, Switzerland24 - Aug - 202528 - Aug - 20258950 GBPPDF Register
Istanbul, Turkey28 - Sep - 202502 - Oct - 20254700 GBPPDF Register
Bali, Indonesia28 - Sep - 202502 - Oct - 20258100 GBPPDF Register
Singapore, Singapore28 - Sep - 202502 - Oct - 20257500 GBPPDF Register
Washington, United States28 - Sep - 202502 - Oct - 202511000 GBPPDF Register
Dubai, UAE07 - Sep - 202511 - Sep - 20254987.5 GBPPDF Register
Paris, France07 - Sep - 202511 - Sep - 20256700 GBPPDF Register
Hong Kong, Hong Kong07 - Sep - 202511 - Sep - 20258500 GBPPDF Register
Tokyo, Japan07 - Sep - 202511 - Sep - 20259750 GBPPDF Register
Dubai, UAE14 - Sep - 202518 - Sep - 20254987.5 GBPPDF Register
Paris, France14 - Sep - 202518 - Sep - 20256700 GBPPDF Register
Hong Kong, Hong Kong14 - Sep - 202518 - Sep - 20258500 GBPPDF Register
Tokyo, Japan14 - Sep - 202518 - Sep - 20259750 GBPPDF Register
Kuala Lumpur, Malaysia21 - Sep - 202525 - Sep - 20254750 GBPPDF Register
Rome, Italy21 - Sep - 202525 - Sep - 20257300 GBPPDF Register
Barcelona, Spain21 - Sep - 202525 - Sep - 20256950 GBPPDF Register
Zurich, Switzerland21 - Sep - 202525 - Sep - 20257950 GBPPDF Register
London, UK07 - Sep - 202511 - Sep - 20254950 GBPPDF Register
Madrid, Spain07 - Sep - 202511 - Sep - 20256950 GBPPDF Register
Munich, Germany07 - Sep - 202511 - Sep - 20257900 GBPPDF Register
Berlin, Germany07 - Sep - 202511 - Sep - 20257900 GBPPDF Register
New York, United States07 - Sep - 202511 - Sep - 202510900 GBPPDF Register
Amsterdam, Netherlands07 - Sep - 202511 - Sep - 20258100 GBPPDF Register
Milan, Italy07 - Sep - 202511 - Sep - 20256950 GBPPDF Register
London, UK14 - Sep - 202518 - Sep - 20254950 GBPPDF Register
Madrid, Spain14 - Sep - 202518 - Sep - 20256950 GBPPDF Register
Munich, Germany14 - Sep - 202518 - Sep - 20257900 GBPPDF Register
Berlin, Germany14 - Sep - 202518 - Sep - 20257900 GBPPDF Register
New York, United States14 - Sep - 202518 - Sep - 202510900 GBPPDF Register
Amsterdam, Netherlands14 - Sep - 202518 - Sep - 20258100 GBPPDF Register
Milan, Italy14 - Sep - 202518 - Sep - 20256950 GBPPDF Register
Taipei, Taiwan28 - Sep - 202502 - Oct - 20259300 GBPPDF Register
Sydney, Australia21 - Sep - 202525 - Sep - 202510900 GBPPDF Register
Interlaken, Switzerland21 - Sep - 202525 - Sep - 20258950 GBPPDF Register
London, UK19 - Oct - 202523 - Oct - 20254950 GBPPDF Register
Madrid, Spain19 - Oct - 202523 - Oct - 20256950 GBPPDF Register
Munich, Germany19 - Oct - 202523 - Oct - 20257900 GBPPDF Register
Berlin, Germany19 - Oct - 202523 - Oct - 20257900 GBPPDF Register
New York, United States19 - Oct - 202523 - Oct - 202510900 GBPPDF Register
Amsterdam, Netherlands19 - Oct - 202523 - Oct - 20258100 GBPPDF Register
Milan, Italy19 - Oct - 202523 - Oct - 20256950 GBPPDF Register
Istanbul, Turkey05 - Oct - 202509 - Oct - 20254700 GBPPDF Register
Bali, Indonesia05 - Oct - 202509 - Oct - 20258100 GBPPDF Register
Singapore, Singapore05 - Oct - 202509 - Oct - 20257500 GBPPDF Register
Washington, United States05 - Oct - 202509 - Oct - 202511000 GBPPDF Register
Kuala Lumpur, Malaysia12 - Oct - 202516 - Oct - 20254750 GBPPDF Register
Rome, Italy12 - Oct - 202516 - Oct - 20257300 GBPPDF Register
Barcelona, Spain12 - Oct - 202516 - Oct - 20256950 GBPPDF Register
Zurich, Switzerland12 - Oct - 202516 - Oct - 20257950 GBPPDF Register
Dubai, UAE05 - Oct - 202509 - Oct - 20254987.5 GBPPDF Register
Paris, France05 - Oct - 202509 - Oct - 20256700 GBPPDF Register
Hong Kong, Hong Kong05 - Oct - 202509 - Oct - 20258500 GBPPDF Register
Tokyo, Japan05 - Oct - 202509 - Oct - 20259750 GBPPDF Register
London, UK05 - Oct - 202509 - Oct - 20254950 GBPPDF Register
Madrid, Spain05 - Oct - 202509 - Oct - 20256950 GBPPDF Register
Munich, Germany05 - Oct - 202509 - Oct - 20257900 GBPPDF Register
Berlin, Germany05 - Oct - 202509 - Oct - 20257900 GBPPDF Register
New York, United States05 - Oct - 202509 - Oct - 202510900 GBPPDF Register
Amsterdam, Netherlands05 - Oct - 202509 - Oct - 20258100 GBPPDF Register
Milan, Italy05 - Oct - 202509 - Oct - 20256950 GBPPDF Register
Taipei, Taiwan05 - Oct - 202509 - Oct - 20259300 GBPPDF Register
Sydney, Australia12 - Oct - 202516 - Oct - 202510900 GBPPDF Register
Interlaken, Switzerland12 - Oct - 202516 - Oct - 20258950 GBPPDF Register

Courses 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

Available Cities

@2025 London Business Training Academy