- Learn the importance of sensitivity analysis and how to implement it.
- Master the core features, operations and short-cuts of Excel required to build common types of simple models.
- Gain practical experience in building and using models.
- Overview. This course covers the main functionalities and short-cuts in Excel that are necessary to build models and conduct data analysis. It covers the topic of sensitivity analysis, describing how it is essential when designing, building and using models. It includes exercises relating to sensitivity analysis in various modelling contexts, including one- and two-way analysis, and time-based forecasting models. The course also covers some fundamental types of calculations and structures used in modelling, such as forecasting using growth-rate and ratio-driven approaches, logic reversals, and corkscrew and reverse corkscrew structures.
- Practical work and exercises. Students are required to conduct numerous hands-on modelling exercises and can also follow along by replicating other examples that are shown in the text.
- Assessment tests. There are 8 assessment tests which test the key concepts and require one to do practical exercises in Excel, including for breakeven analysis, general forecasting using growth and ratios, sensitivity analysis, and more!
- Sensitivity analysis. Uses and importance. Sensitivity analysis in model design. Manual and automatic sensitivity analysis. DataTables. One-way analysis. Two-way analysis. Sensitivity analysis in time-based forecasts. Using GoalSeek.
- Excel functionality and core operations. Copy, paste, insert, delete, undo. Using Find/Replace in modelling and data analysis. Wildcard characters. GoTo and GoTo Special. Efficient selection of ranges. Navigation around a model. Short-cuts and KeyTips.
- Named ranges. Use in formulas and model navigation. Advantages and disadvantages.
- Formatting and graphics. General formatting. Conditional formatting. Custom formatting. Principles of effective visual communication. Using graphs and charts in Excel.
- Common calculations and modelling structures. Growth-based forecasting, ratio-driven calculations, mapping historical data and forecast assumptions, logic reversals, corkscrews and reverse corkscrews.