Advanced Sensitivity Modeling
This 2 to 4 hour (depending on material to be covered) advanced modeling seminar is designed to give modelers practical skills to create fast and flexible sensitivity tools in spreadsheet-based forecast models. Participants will get hands-on practice building and applying three key techniques to make their models answer "what-if" questions easily.
Skills / Knowledge
- Employ a sophisticated and scalable scenario manager in any model
- Utilize efficient and intuitive controls to manage timing flexibility and events within the forecasting model
- Use advanced techniques to automatically capture scenario outputs for summaries and comparisons
- Other helpful techniques, modeling approaches and formulas will be covered
- A chance for questions and answers on common modeling issues and challenges (time permitting)
- Participants will construct a data table that allows them to analyze beyond the normal two variable limit for this technique
- Output and summary automation techniques will also be discussed