Author
Released
11/28/2017- 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
Duration
Views
- [Curt] Hi, I'm Curt Frye. Welcome to the course. In this course, I will show you how to analyze past data and project into the future. I will provide an overview of scenario analysis and explore the link between scenarios and the storytelling. Next I'll show you how to manage scenarios in Excel using static values, using percentages of base values, and by showing and hiding details as required.
After that, I'll show you how to summarize data using the Normal Distribution, indicate the probability of a scenario occurring and estimate values given limited information using the triangular distribution. Finally, I'll show you how to analyze retrospective data by creating pivot tables, focusing on specific data, and recalling pivot table positions using macros. In short, I think you'll find that the material in this course will be well worth your time.
Dive right in.
Related Courses
-
Excel 2016: Business Process Analysis
with Curt Frye1h 25m Intermediate
-
Introduction
-
Welcome1m 3s
-
-
1. Introducing the Art of Scenario Planning
-
2. Manage Scenarios in Excel
-
3. Establish Parameter Value Ranges
-
4. Present Scenarios Using PivotTables
-
Define PivotTable dataset6m 23s
-
Filter PivotTable data5m 10s
-
Link a macro to a shape6m 27s
-
-
Conclusion
-
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.
CancelTake 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.
Share this video
Embed this video
Video: Welcome