/  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
    17 - 11 - 2019
    21 - 11 - 2019
  • Bali
    17 - 11 - 2019
    21 - 11 - 2019
  • Singapore
    17 - 11 - 2019
    21 - 11 - 2019
  • Washington
    17 - 11 - 2019
    21 - 11 - 2019
  • Dubai
    24 - 11 - 2019
    28 - 11 - 2019
  • Paris
    24 - 11 - 2019
    28 - 11 - 2019
  • Hong Kong
    24 - 11 - 2019
    28 - 11 - 2019
  • London
    24 - 11 - 2019
    28 - 11 - 2019
  • Madrid
    24 - 11 - 2019
    28 - 11 - 2019
  • Munich
    24 - 11 - 2019
    28 - 11 - 2019
  • Berlin
    24 - 11 - 2019
    28 - 11 - 2019
  • New York
    24 - 11 - 2019
    28 - 11 - 2019
  • London
    15 - 12 - 2019
    19 - 12 - 2019
  • Madrid
    15 - 12 - 2019
    19 - 12 - 2019
  • Munich
    15 - 12 - 2019
    19 - 12 - 2019
  • Berlin
    15 - 12 - 2019
    19 - 12 - 2019
  • New York
    15 - 12 - 2019
    19 - 12 - 2019
  • Dubai
    22 - 12 - 2019
    26 - 12 - 2019
  • Paris
    22 - 12 - 2019
    26 - 12 - 2019
  • Hong Kong
    22 - 12 - 2019
    26 - 12 - 2019
  • Istanbul
    8 - 12 - 2019
    12 - 12 - 2019
  • Bali
    8 - 12 - 2019
    12 - 12 - 2019
  • Singapore
    8 - 12 - 2019
    12 - 12 - 2019
  • Washington
    8 - 12 - 2019
    12 - 12 - 2019
  • Kuala Lumpur
    1 - 12 - 2019
    5 - 12 - 2019
  • Rome
    1 - 12 - 2019
    5 - 12 - 2019
  • Barcelona
    1 - 12 - 2019
    5 - 12 - 2019
  • Zurich
    1 - 12 - 2019
    5 - 12 - 2019
  • Istanbul
    26 - 1 - 2020
    30 - 1 - 2020
  • Bali
    26 - 1 - 2020
    30 - 1 - 2020
  • Singapore
    26 - 1 - 2020
    30 - 1 - 2020
  • Washington
    26 - 1 - 2020
    30 - 1 - 2020
  • Dubai
    19 - 1 - 2020
    23 - 1 - 2020
  • Paris
    19 - 1 - 2020
    23 - 1 - 2020
  • Hong Kong
    19 - 1 - 2020
    23 - 1 - 2020
  • Dubai
    12 - 1 - 2020
    16 - 1 - 2020
  • Paris
    12 - 1 - 2020
    16 - 1 - 2020
  • Hong Kong
    12 - 1 - 2020
    16 - 1 - 2020
  • Kuala Lumpur
    5 - 1 - 2020
    9 - 1 - 2020
  • Rome
    5 - 1 - 2020
    9 - 1 - 2020
  • Barcelona
    5 - 1 - 2020
    9 - 1 - 2020
  • Zurich
    5 - 1 - 2020
    9 - 1 - 2020
  • London
    19 - 1 - 2020
    23 - 1 - 2020
  • Madrid
    19 - 1 - 2020
    23 - 1 - 2020
  • Munich
    19 - 1 - 2020
    23 - 1 - 2020
  • Berlin
    19 - 1 - 2020
    23 - 1 - 2020
  • New York
    19 - 1 - 2020
    23 - 1 - 2020
  • London
    23 - 2 - 2020
    27 - 2 - 2020
  • Madrid
    23 - 2 - 2020
    27 - 2 - 2020
  • Munich
    23 - 2 - 2020
    27 - 2 - 2020
  • Berlin
    23 - 2 - 2020
    27 - 2 - 2020
  • New York
    23 - 2 - 2020
    27 - 2 - 2020
  • Dubai
    16 - 2 - 2020
    20 - 2 - 2020
  • Paris
    16 - 2 - 2020
    20 - 2 - 2020
  • Hong Kong
    16 - 2 - 2020
    20 - 2 - 2020
  • Istanbul
    9 - 2 - 2020
    13 - 2 - 2020
  • Bali
    9 - 2 - 2020
    13 - 2 - 2020
  • Singapore
    9 - 2 - 2020
    13 - 2 - 2020
  • Washington
    9 - 2 - 2020
    13 - 2 - 2020
  • Kuala Lumpur
    2 - 2 - 2020
    6 - 2 - 2020
  • Rome
    2 - 2 - 2020
    6 - 2 - 2020
  • Barcelona
    2 - 2 - 2020
    6 - 2 - 2020
  • Zurich
    2 - 2 - 2020
    6 - 2 - 2020
  • Istanbul
    15 - 3 - 2020
    19 - 3 - 2020
  • Bali
    15 - 3 - 2020
    19 - 3 - 2020
  • Singapore
    15 - 3 - 2020
    19 - 3 - 2020
  • Washington
    15 - 3 - 2020
    19 - 3 - 2020
  • Dubai
    8 - 3 - 2020
    12 - 3 - 2020
  • Paris
    8 - 3 - 2020
    12 - 3 - 2020
  • Hong Kong
    8 - 3 - 2020
    12 - 3 - 2020
  • Dubai
    1 - 3 - 2020
    5 - 3 - 2020
  • Paris
    1 - 3 - 2020
    5 - 3 - 2020
  • Hong Kong
    1 - 3 - 2020
    5 - 3 - 2020
  • Kuala Lumpur
    22 - 3 - 2020
    26 - 3 - 2020
  • Rome
    22 - 3 - 2020
    26 - 3 - 2020
  • Barcelona
    22 - 3 - 2020
    26 - 3 - 2020
  • Zurich
    22 - 3 - 2020
    26 - 3 - 2020
  • London
    8 - 3 - 2020
    12 - 3 - 2020
  • Madrid
    8 - 3 - 2020
    12 - 3 - 2020
  • Munich
    8 - 3 - 2020
    12 - 3 - 2020
  • Berlin
    8 - 3 - 2020
    12 - 3 - 2020
  • New York
    8 - 3 - 2020
    12 - 3 - 2020
  • London
    26 - 4 - 2020
    30 - 4 - 2020
  • Madrid
    26 - 4 - 2020
    30 - 4 - 2020
  • Munich
    26 - 4 - 2020
    30 - 4 - 2020
  • Berlin
    26 - 4 - 2020
    30 - 4 - 2020
  • New York
    26 - 4 - 2020
    30 - 4 - 2020
  • Dubai
    5 - 4 - 2020
    9 - 4 - 2020
  • Paris
    5 - 4 - 2020
    9 - 4 - 2020
  • Hong Kong
    5 - 4 - 2020
    9 - 4 - 2020
  • Istanbul
    12 - 4 - 2020
    16 - 4 - 2020
  • Bali
    12 - 4 - 2020
    16 - 4 - 2020
  • Singapore
    12 - 4 - 2020
    16 - 4 - 2020
  • Washington
    12 - 4 - 2020
    16 - 4 - 2020
  • Kuala Lumpur
    19 - 4 - 2020
    23 - 4 - 2020
  • Rome
    19 - 4 - 2020
    23 - 4 - 2020
  • Barcelona
    19 - 4 - 2020
    23 - 4 - 2020
  • Zurich
    19 - 4 - 2020
    23 - 4 - 2020
  • Istanbul
    10 - 5 - 2020
    14 - 5 - 2020
  • Bali
    10 - 5 - 2020
    14 - 5 - 2020
  • Singapore
    10 - 5 - 2020
    14 - 5 - 2020
  • Washington
    10 - 5 - 2020
    14 - 5 - 2020
  • Dubai
    3 - 5 - 2020
    7 - 5 - 2020
  • Paris
    3 - 5 - 2020
    7 - 5 - 2020
  • Hong Kong
    3 - 5 - 2020
    7 - 5 - 2020
  • Dubai
    17 - 5 - 2020
    21 - 5 - 2020
  • Paris
    17 - 5 - 2020
    21 - 5 - 2020
  • Hong Kong
    17 - 5 - 2020
    21 - 5 - 2020
  • Kuala Lumpur
    24 - 5 - 2020
    28 - 5 - 2020
  • Rome
    24 - 5 - 2020
    28 - 5 - 2020
  • Barcelona
    24 - 5 - 2020
    28 - 5 - 2020
  • Zurich
    24 - 5 - 2020
    28 - 5 - 2020
  • London
    3 - 5 - 2020
    7 - 5 - 2020
  • Madrid
    3 - 5 - 2020
    7 - 5 - 2020
  • Munich
    3 - 5 - 2020
    7 - 5 - 2020
  • Berlin
    3 - 5 - 2020
    7 - 5 - 2020
  • New York
    3 - 5 - 2020
    7 - 5 - 2020
  • London
    14 - 6 - 2020
    18 - 6 - 2020
  • Madrid
    14 - 6 - 2020
    18 - 6 - 2020
  • Munich
    14 - 6 - 2020
    18 - 6 - 2020
  • Berlin
    14 - 6 - 2020
    18 - 6 - 2020
  • New York
    14 - 6 - 2020
    18 - 6 - 2020
  • Dubai
    21 - 6 - 2020
    25 - 6 - 2020
  • Paris
    21 - 6 - 2020
    25 - 6 - 2020
  • Hong Kong
    21 - 6 - 2020
    25 - 6 - 2020
  • Istanbul
    28 - 6 - 2020
    2 - 7 - 2020
  • Bali
    28 - 6 - 2020
    2 - 7 - 2020
  • Singapore
    28 - 6 - 2020
    2 - 7 - 2020
  • Washington
    28 - 6 - 2020
    2 - 7 - 2020
  • Kuala Lumpur
    7 - 6 - 2020
    11 - 6 - 2020
  • Rome
    7 - 6 - 2020
    11 - 6 - 2020
  • Barcelona
    7 - 6 - 2020
    11 - 6 - 2020
  • Zurich
    7 - 6 - 2020
    11 - 6 - 2020
  • Istanbul
    5 - 7 - 2020
    9 - 7 - 2020
  • Bali
    5 - 7 - 2020
    9 - 7 - 2020
  • Singapore
    5 - 7 - 2020
    9 - 7 - 2020
  • Washington
    5 - 7 - 2020
    9 - 7 - 2020
  • Dubai
    12 - 7 - 2020
    16 - 7 - 2020
  • Paris
    12 - 7 - 2020
    16 - 7 - 2020
  • Hong Kong
    12 - 7 - 2020
    16 - 7 - 2020
  • Dubai
    19 - 7 - 2020
    23 - 7 - 2020
  • Paris
    19 - 7 - 2020
    23 - 7 - 2020
  • Hong Kong
    19 - 7 - 2020
    23 - 7 - 2020
  • Kuala Lumpur
    26 - 7 - 2020
    30 - 7 - 2020
  • Rome
    26 - 7 - 2020
    30 - 7 - 2020
  • Barcelona
    26 - 7 - 2020
    30 - 7 - 2020
  • Zurich
    26 - 7 - 2020
    30 - 7 - 2020
  • London
    12 - 7 - 2020
    16 - 7 - 2020
  • Madrid
    12 - 7 - 2020
    16 - 7 - 2020
  • Munich
    12 - 7 - 2020
    16 - 7 - 2020
  • Berlin
    12 - 7 - 2020
    16 - 7 - 2020
  • New York
    12 - 7 - 2020
    16 - 7 - 2020
  • London
    19 - 7 - 2020
    23 - 7 - 2020
  • Madrid
    19 - 7 - 2020
    23 - 7 - 2020
  • Munich
    19 - 7 - 2020
    23 - 7 - 2020
  • Berlin
    19 - 7 - 2020
    23 - 7 - 2020
  • New York
    19 - 7 - 2020
    23 - 7 - 2020
  • London
    2 - 8 - 2020
    6 - 8 - 2020
  • Madrid
    2 - 8 - 2020
    6 - 8 - 2020
  • Munich
    2 - 8 - 2020
    6 - 8 - 2020
  • Berlin
    2 - 8 - 2020
    6 - 8 - 2020
  • New York
    2 - 8 - 2020
    6 - 8 - 2020
  • Dubai
    9 - 8 - 2020
    13 - 8 - 2020
  • Paris
    9 - 8 - 2020
    13 - 8 - 2020
  • Hong Kong
    9 - 8 - 2020
    13 - 8 - 2020
  • Istanbul
    16 - 8 - 2020
    20 - 8 - 2020
  • Bali
    16 - 8 - 2020
    20 - 8 - 2020
  • Singapore
    16 - 8 - 2020
    20 - 8 - 2020
  • Washington
    16 - 8 - 2020
    20 - 8 - 2020
  • Kuala Lumpur
    23 - 8 - 2020
    27 - 8 - 2020
  • Rome
    23 - 8 - 2020
    27 - 8 - 2020
  • Barcelona
    23 - 8 - 2020
    27 - 8 - 2020
  • Zurich
    23 - 8 - 2020
    27 - 8 - 2020
  • Istanbul
    27 - 9 - 2020
    1 - 10 - 2020
  • Bali
    27 - 9 - 2020
    1 - 10 - 2020
  • Singapore
    27 - 9 - 2020
    1 - 10 - 2020
  • Washington
    27 - 9 - 2020
    1 - 10 - 2020
  • Dubai
    6 - 9 - 2020
    10 - 9 - 2020
  • Paris
    6 - 9 - 2020
    10 - 9 - 2020
  • Hong Kong
    6 - 9 - 2020
    10 - 9 - 2020
  • Dubai
    13 - 9 - 2020
    17 - 9 - 2020
  • Paris
    13 - 9 - 2020
    17 - 9 - 2020
  • Hong Kong
    13 - 9 - 2020
    17 - 9 - 2020
  • Kuala Lumpur
    20 - 9 - 2020
    24 - 9 - 2020
  • Rome
    20 - 9 - 2020
    24 - 9 - 2020
  • Barcelona
    20 - 9 - 2020
    24 - 9 - 2020
  • Zurich
    20 - 9 - 2020
    24 - 9 - 2020
  • London
    6 - 9 - 2020
    10 - 9 - 2020
  • Madrid
    6 - 9 - 2020
    10 - 9 - 2020
  • Munich
    6 - 9 - 2020
    10 - 9 - 2020
  • Berlin
    6 - 9 - 2020
    10 - 9 - 2020
  • New York
    6 - 9 - 2020
    10 - 9 - 2020
  • Istanbul
    4 - 10 - 2020
    8 - 10 - 2020
  • Bali
    4 - 10 - 2020
    8 - 10 - 2020
  • Singapore
    4 - 10 - 2020
    8 - 10 - 2020
  • Washington
    4 - 10 - 2020
    8 - 10 - 2020

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