MS Excel

Introduction
Functions
Random numbers
Data tables
Advanced functions
Goal Seek/ Solver
Data Analysis

VBA

Introduction
VBA fundamentals
Sub procedures
Function procedures
VBA techniques
User Form
Advanced User Form

Basic financial application which will be solved by MS Excel and VBA

Basics finance calculation
Net present Value, compounding interest

Corporate Finance
Cost of Capital
Financial Statement modeling
Valuation

Portfolio Models
Variance-covariance matrix
Betas and SML
Optimalization
Value at Risk

Option Pricing
Binomial option pricing
Black&Sholes