/  Advanced Modeling with Excel and Visual Basic for Applications Training

Advanced Modeling with Excel and Visual Basic for Applications Training

BMC Training provides a training course in Advanced Modeling with Excel and Visual Basic for Applications in Finance , Accounting and Budgeting

Course Title
Venue
Start Date
End Date
  • Istanbul
    3 - 7 - 2022
    7 - 7 - 2022
  • Dubai
    10 - 7 - 2022
    14 - 7 - 2022
  • Paris
    10 - 7 - 2022
    14 - 7 - 2022
  • London
    10 - 7 - 2022
    14 - 7 - 2022
  • Madrid
    10 - 7 - 2022
    14 - 7 - 2022
  • Berlin
    10 - 7 - 2022
    14 - 7 - 2022
  • Dubai
    17 - 7 - 2022
    21 - 7 - 2022
  • Paris
    17 - 7 - 2022
    21 - 7 - 2022
  • London
    17 - 7 - 2022
    21 - 7 - 2022
  • Madrid
    17 - 7 - 2022
    21 - 7 - 2022
  • Berlin
    17 - 7 - 2022
    21 - 7 - 2022
  • Kuala Lumpur
    24 - 7 - 2022
    28 - 7 - 2022
  • Rome
    24 - 7 - 2022
    28 - 7 - 2022
  • Barcelona
    24 - 7 - 2022
    28 - 7 - 2022
  • Zurich
    24 - 7 - 2022
    28 - 7 - 2022
  • London
    7 - 8 - 2022
    11 - 8 - 2022
  • Madrid
    7 - 8 - 2022
    11 - 8 - 2022
  • Berlin
    7 - 8 - 2022
    11 - 8 - 2022
  • Dubai
    14 - 8 - 2022
    18 - 8 - 2022
  • Paris
    14 - 8 - 2022
    18 - 8 - 2022
  • Istanbul
    21 - 8 - 2022
    25 - 8 - 2022
  • Dubai
    21 - 8 - 2022
    25 - 8 - 2022
  • Paris
    21 - 8 - 2022
    25 - 8 - 2022
  • Kuala Lumpur
    28 - 8 - 2022
    1 - 9 - 2022
  • Rome
    28 - 8 - 2022
    1 - 9 - 2022
  • Barcelona
    28 - 8 - 2022
    1 - 9 - 2022
  • Zurich
    28 - 8 - 2022
    1 - 9 - 2022
  • Dubai
    4 - 9 - 2022
    8 - 9 - 2022
  • Paris
    4 - 9 - 2022
    8 - 9 - 2022
  • London
    4 - 9 - 2022
    8 - 9 - 2022
  • Madrid
    4 - 9 - 2022
    8 - 9 - 2022
  • Berlin
    4 - 9 - 2022
    8 - 9 - 2022
  • Dubai
    11 - 9 - 2022
    15 - 9 - 2022
  • Paris
    11 - 9 - 2022
    15 - 9 - 2022
  • Kuala Lumpur
    18 - 9 - 2022
    22 - 9 - 2022
  • Rome
    18 - 9 - 2022
    22 - 9 - 2022
  • Barcelona
    18 - 9 - 2022
    22 - 9 - 2022
  • Zurich
    18 - 9 - 2022
    22 - 9 - 2022
  • Istanbul
    25 - 9 - 2022
    29 - 9 - 2022
  • Istanbul
    2 - 10 - 2022
    6 - 10 - 2022
  • Dubai
    2 - 10 - 2022
    6 - 10 - 2022
  • Paris
    2 - 10 - 2022
    6 - 10 - 2022
  • Kuala Lumpur
    9 - 10 - 2022
    13 - 10 - 2022
  • Rome
    9 - 10 - 2022
    13 - 10 - 2022
  • Barcelona
    9 - 10 - 2022
    13 - 10 - 2022
  • Zurich
    9 - 10 - 2022
    13 - 10 - 2022
  • London
    16 - 10 - 2022
    20 - 10 - 2022
  • Madrid
    16 - 10 - 2022
    20 - 10 - 2022
  • Berlin
    16 - 10 - 2022
    20 - 10 - 2022
  • Dubai
    23 - 10 - 2022
    27 - 10 - 2022
  • Paris
    23 - 10 - 2022
    27 - 10 - 2022
  • Dubai
    6 - 11 - 2022
    10 - 11 - 2022
  • Paris
    6 - 11 - 2022
    10 - 11 - 2022
  • Kuala Lumpur
    13 - 11 - 2022
    17 - 11 - 2022
  • Rome
    13 - 11 - 2022
    17 - 11 - 2022
  • Barcelona
    13 - 11 - 2022
    17 - 11 - 2022
  • Zurich
    13 - 11 - 2022
    17 - 11 - 2022
  • Istanbul
    20 - 11 - 2022
    24 - 11 - 2022
  • Dubai
    27 - 11 - 2022
    1 - 12 - 2022
  • Paris
    27 - 11 - 2022
    1 - 12 - 2022
  • London
    27 - 11 - 2022
    1 - 12 - 2022
  • Madrid
    27 - 11 - 2022
    1 - 12 - 2022
  • Berlin
    27 - 11 - 2022
    1 - 12 - 2022
  • Kuala Lumpur
    4 - 12 - 2022
    8 - 12 - 2022
  • Rome
    4 - 12 - 2022
    8 - 12 - 2022
  • Barcelona
    4 - 12 - 2022
    8 - 12 - 2022
  • Zurich
    4 - 12 - 2022
    8 - 12 - 2022
  • Istanbul
    11 - 12 - 2022
    15 - 12 - 2022
  • Dubai
    11 - 12 - 2022
    15 - 12 - 2022
  • Paris
    11 - 12 - 2022
    15 - 12 - 2022
  • London
    18 - 12 - 2022
    22 - 12 - 2022
  • Madrid
    18 - 12 - 2022
    22 - 12 - 2022
  • Berlin
    18 - 12 - 2022
    22 - 12 - 2022
  • Dubai
    25 - 12 - 2022
    29 - 12 - 2022
  • Paris
    25 - 12 - 2022
    29 - 12 - 2022

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

Courses Search

Recent Posts

Connect with us

IFRS Preparation. (5 Days)Available in London - Dubai - Istanbul - Kuala Lumpur

Join our Civil and Construction Engineering Training Courses , Electrical and Power Engineering Training Courses and Facilities Management Training

Technical Training Courses

Newsletter