Overview
-
Explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- Describe scenarios and scenario planning
- Explore the link between scenarios and storytelling
- Design a scenario-planning exercise
- Estimate scenario plausibility and outcomes
- Define scenarios using static values
- Define scenarios using percentages of base values
- Select scenarios using data validation rules
- Show and hide details by grouping worksheet rows
- Walk through a scenario presentation
- Introduce the normal distribution
- Calculate the standard deviation of a dataset
- Indicate the probability of a scenario value occurring
- Estimate values using the triangular distribution
- Walk through a scenario presentation
- Define PivotTable dataset
- Create and pivot a PivotTable
- Summarize PivotTable data using subtotals and grand totals
- Filter PivotTable data
- Change the values area summary operation
- Record a macro to recreate a PivotTable position
- Link a macro to a shape
- Walk through a scenario presentation
- Next steps
