Spreadsheet Modelling for Quantitative Finance

This module provides an introduction to spreadsheet modelling skills in Excel. The outline syllabus will include the topics of:

• Spreadsheet layout and model design
• Data analysis including descriptive statistics and charts
• VBA
• Simulation in Excel
• Optimisation in Excel