Advanced Modeling with Excel and Visual Basic for Applications

Advanced Modeling with Excel and Visual Basic for Applications


Choose from the following table the course date which you would like to attend the course on :

Sart
End
Fees
Venue
Length
18-FEB-2018
1-MAR-2018
7500$
Istanbul (Turkey)
One Week
Click Here
25-MAR-2018
5-APR-2018
4700$
Dubai (UAE)
One Week
Click Here
18-MAR-2018
29-MAR-2018
6950$
Paris (France)
One Week
Click Here
1-APR-2018
12-APR-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
22-APR-2018
3-MAY-2018
5700$
London (UK)
One Week
Click Here
29-APR-2018
10-MAY-2018
7500$
Istanbul (Turkey)
One Week
Click Here
13-MAY-2018
24-MAY-2018
7500$
Istanbul (Turkey)
One Week
Click Here
20-MAY-2018
31-MAY-2018
4700$
Dubai (UAE)
One Week
Click Here
13-MAY-2018
24-MAY-2018
6950$
Paris (France)
One Week
Click Here
24-JUN-2018
5-JUL-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
3-JUN-2018
14-JUN-2018
5700$
London (UK)
One Week
Click Here
1-JUL-2018
12-JUL-2018
7500$
Istanbul (Turkey)
One Week
Click Here
22-JUL-2018
2-AUG-2018
4700$
Dubai (UAE)
One Week
Click Here
1-JUL-2018
12-JUL-2018
6950$
Paris (France)
One Week
Click Here
19-AUG-2018
30-AUG-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
12-AUG-2018
23-AUG-2018
5700$
London (UK)
One Week
Click Here
23-SEP-2018
4-OCT-2018
7500$
Istanbul (Turkey)
One Week
Click Here
2-SEP-2018
13-SEP-2018
4700$
Dubai (UAE)
One Week
Click Here
23-SEP-2018
4-OCT-2018
6950$
Paris (France)
One Week
Click Here
14-OCT-2018
25-OCT-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
7-OCT-2018
18-OCT-2018
5700$
London (UK)
One Week
Click Here
4-NOV-2018
15-NOV-2018
7500$
Istanbul (Turkey)
One Week
Click Here
18-NOV-2018
29-NOV-2018
4700$
Dubai (UAE)
One Week
Click Here
4-NOV-2018
15-NOV-2018
6950$
Paris (France)
One Week
Click Here
2-DEC-2018
13-DEC-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
23-DEC-2018
3-JAN-2019
5700$
London (UK)
One Week
Click Here
27-JAN-2019
7-FEB-2019
7500$
Istanbul (Turkey)
One Week
Click Here
6-JAN-2019
17-JAN-2019
4700$
Dubai (UAE)
One Week
Click Here
27-JAN-2019
7-FEB-2019
6950$
Paris (France)
One Week
Click Here
10-FEB-2019
21-FEB-2019
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
3-FEB-2019
14-FEB-2019
5700$
London (UK)
One Week
Click Here

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

Get Information / Register