Introduction -- Advanced Excel Functions and Procedures -- Introduction to VBA -- Writing VBA User-Defined Functions -- Introduction to Equities -- Portfolio Optimisation -- Asset Pricing -- Performance Measurement and Attribution -- Introduction to Options on Equities -- Binomial Trees -- The Black -- Scholes Formula -- Other Numerical Methods for European Options -- Non-Normal Distributions and Implied Volatility -- Introduction to Valuing Options on Bonds -- Interest Rate Models -- Matching the Term Structure -- Appendix: Other VBA Functions.