Join Curt Frye for an in-depth discussion in this video Next steps, part of Excel: Scenario Planning and Analysis.
- [Instructor] Thanks again for working through this course.…I learned a lot preparing it,…and I hope you got a lot out of it as well.…Before I go, I would like…to give you three additional resources…that you can use to learn related skills.…The first is a lynda.com course,…Storytelling for Designers by Stacey Williams-Ng.…It's a terrific course,…and it goes into more detail…of the storytelling perspectives…that are described in my course.…Also, if you want to learn more about Excel PivotTables,…I highly recommend Excel 2016: PivotTables in Depth.…
That's my course on lynda.com.…I have other courses for PivotTables…in Excel versions going back to 2007.…And finally, a book that I mentioned…within the course is Strategic Reframing…by Rafael Ramirez and Angela Wilkinson.…It's a book from Oxford University Press,…and it discusses the Oxford Scenario Program's approach…to scenario analysis in business and policy.…Each of these three additional resources…provides useful skills for you,…and I think you'll get a lot out of 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.