OVERVIEW IN KEYWORDS
The following summarises the content of the course using key words. More information can be seen by clicking the “More details” buttons.
I Foundations of Modelling and Analysis with Excel
Modelling definitions and uses. Decision support and criteria. Skills required. Model mapping and influence diagrams. Excel structure, core operations, and short-cuts. Sensitivity analysis. DataTables. GoalSeek. Model navigation. Auditing and dependency tracing. Calculation options. Formatting, presentation, graphs and charts. Excel functions for information, aggregation, and conditionality. Dynamic arrays and array functions. Lookup functions. Scenario analysis. Payback and breakeven analysis. Common formulas and structures. Growth- and ratio-based forecasts. Corkscrews, flags, waterfalls, time allocations and triangles.
Modelling exercises and quizzes.