Scenario planning exercises that examine strategies for the next 2, 5, or 10 years are expensive, and apply more to executives and senior managers than at the program or product level.
- [Instructor] Scenario planning exercises…that examine strategies for the next two, five,…or 10 years are expensive…and frankly, they apply more to executives…and senior managers than at the program, project,…or product level.…Even so, we can use the same techniques for our own work…for prospective scenario generation.…When you're look at the tactical level…and trying to determine what's going to happen next,…typically, you want to bring in as many people…as possible into the room…and then ask them questions about what's been going on.…
The problem, of course, is that also costs money…and you have to be able to bring everyone together…and coordinate their schedules,…which is almost impossible,…and even though it might not cost you as much…as an executive lunch,…it is still costing you some money,…and of course, there's an opportunity cost in productivity.…That means as someone who's performing scenario analysis,…you need to be able to interact…with people on their own terms…and get in touch in the way that works best for them.…
- Designing a scenario-planning exercise
- Estimating scenario plausibility and outcomes
- Establishing parameter value ranges
- Calculating the standard deviation of a dataset
- Indicating the probability of a scenario value occurring
- Walking through a scenario presentation
- Performing retrospective analysis using a PivotTable
- Changing PivotTable summary operations
Skill Level Intermediate
Excel 2016: Business Process Analysiswith Curt Frye1h 25m Intermediate
1. Introducing the Art of Scenario Planning
2. Manage Scenarios in Excel
3. Establish Parameter Value Ranges
4. Present Scenarios Using PivotTables
Next steps1m 16s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.