Join Curt Frye for an in-depth discussion in this video Using the exercise files, part of Excel: Scenario Planning and Analysis.
- [Instructor] This course makes reference to a number of exercise files. I have visited the course site and downloaded the files onto my desktop to a folder called exercise files. If I double-click the exercise files folder then I see sub-folders for each of the chapters that have exercise files associated with them. There are no exercise files for chapter one in this course. If I want to open a file, I just go to the chapter folder.
For example, double-clicking chapter three and then double-click the file that I want to use to open it. If you don't want to work with the exercise files, that's no problem. You can just watch the movies and follow along.
- 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
Excel 2016: Power Query (Get & Transform)with Oz du Soleil1h 49m 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.