Introduction
Welcome
(01:03)
Using the exercise files
(00:46)
1. Introducing the Art of Scenario Planning
Describe scenarios and scenario planning
(05:24)
Explore the link between scenarios and storytelling
(05:22)
Design a scenario-planning exercise
(03:53)
Estimate scenario plausibility and outcomes
(05:57)
2. Manage Scenarios in Excel
Define scenarios using static values
(07:52)
Define scenarios using percentages of base values
(06:53)
Select scenarios using data validation rules
(04:20)
Show and hide details by grouping worksheet rows
(04:03)
Walk through a scenario presentation
(04:01)
3. Establish Parameter Value Ranges
Introduce the normal distribution
(03:50)
Calculate the standard deviation of a dataset
(06:57)
Indicate the probability of a scenario value occurring
(06:48)
Estimate values using the triangular distribution
(11:19)
Walk through a scenario presentation
(03:31)
4. Present Scenarios Using PivotTables
Define PivotTable dataset
(06:23)
Create and pivot a PivotTable
(05:30)
Summarize PivotTable data using subtotals and grand totals
(04:22)
Filter PivotTable data
(05:10)
Change the values area summary operation
(05:55)
Record a macro to recreate a PivotTable position
(06:37)
Link a macro to a shape
(06:27)
Walk through a scenario presentation
(03:46)
Conclusion
Next steps
(01:16)
Ex_Files_Excel_Scenario_Planning_Analysis.zip
(21 KB)