Downloads:

• Marcel Finnan FM solutions FMKEY(PDF)

Tutorials

• Videos about everything you might wanna know about excel: ExcelIsFun

Excel Class File:

Exercise 1: write the formulas in excel (formulas file)

Solution: for Gamma and Normal Distributuions

Excercise 2: Introdution to Macro (amortization(macro))

VBA Class Files:

macros file

Note: To access the codes we used during the workshop open the file and under the Developer Tab click on Visual Basic

then under VBAProject(macros.xlrs) double click in module one