1 1 1 Objectives and a Little Spreadsheet History (13.61 MB)
2 1 2 Navigating a spreadsheet and crafting formulas (32.05 MB)
3 1 3 Using functions (9.18 MB)
4 1 4 Using conditional expressions in formulas (9.06 MB)
5 1 5 Common errors in spreadsheets (10.75 MB)
6 1 6 Differences between Sheets and Excel (9.05 MB)
1 2 0 Module Introduction (10.53 MB)
2 2 1 Using assumptions and decision variables in spreadsheet models (6.8 MB)
3 2 2 Structuring a spreadsheet to model variables objectives and objective functions (5.81 MB)
4 2 3 Constructing simple cashflow model (9.73 MB)
5 2 4 Whatif analysis and sensitivity analysis (13.27 MB)
6 2 5 Limits to simple deterministic models (11.52 MB)
1 3 0 Introduction (7.8 MB)
2 3 1 Random variables and probability distributions (20.06 MB)
3 3 2 Changes in discrete and continuous time (13.05 MB)
4 3 3 Power exponential and log functions (16.03 MB)
5 3 4 Probability trees and decision trees (16 MB)
6 3 5 Correlation and Regression (15.96 MB)
1 4 0 Introduction (14.15 MB)
2 4 1 Monte Carlo Simulations (25.8 MB)
3 4 2 Linear Programming (19.2 MB)
4 4 3 Next Steps and Differences between Excel and Sheets (13.57 MB)