The following summarises the content of each course using key words. More information about each course can be seen by clicking the “More details” buttons.
I. Foundations of Modelling with Excel
The definition of modelling. Uses and skills required. Excel structure, operations, and short-cuts. Model mapping and planning. Influence diagrams. Choice of variables. Excel formulas and functions. Graphs and charts. Formatting. Corkscrew, waterfall, and other structures. Best practice principles. Sensitivity analysis. GoalSeek. Scenario analysis. Introduction to risk, uncertainty and optimisation analysis. Decision support, criteria, and challenges. Strategic and contextual analysis. 10 Quizzes.