In this video, learn how to use grouping to store those details on a worksheet without displaying them until you need them.
- [Instructor] Every business scenario comes…with assumptions such as interest rates,…baseline sales performance, and cost of goods sold.…In this movie, I will show you how to use…grouping to store those details in a worksheet…without displaying them until you need them.…My sample file for this movie is Scenarios_02_04…and you can find it in the chapter 2 folder…of your exercise files collection.…This workbook contains a single worksheet…and on it I have scenarios for revenue…and cost of goods sold and their impact on operating income.…
I have six possible scenarios.…Scenarios one through five are built in,…and they go from poor performance to excellent performance,…and number six is left for a custom scenario…that anyone in the room can suggest values for.…If I want to change revenue to a different scenario,…I can click cell H3, click the down arrow,…and let's say I want to go to excellent.…I'll click number 5 and I get my results there.…
I have my revenue values in cells B10 through F16,…and if I scroll down using my mouse wheel,…
- 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.