The key to analyzing business operations under changing assumptions is to define and apply scenarios to your data.
- [Instructor] One method for analyzing business operations…under changing assumptions is to define…and apply scenarios to your data.…In this movie,…I will show you how to define scenarios…using the static values in your worksheet.…My sample file is the scenario's zero two zero one workbook.…It's an Excel file…that you can find in the chapter two folder…of your exercise files collection.…This worksheet has been set up…to calculate operating income,…which is total revenue minus cost of goods sold…for four products.…
And those are designated…basic, advanced, professional, and enterprise.…I've created six different scenarios for the revenue values,…and if I scroll down,…you can also see that I've done the same…for cost of goods sold,…which is usually abbreviated COGS.…To the right, you'll see my scenario codes,…and there's nothing magic about these.…They're just the order that I decided on.…You might decide that one is excellent…and five is poor.…
It all depends on what you're used to working with…within your company.…
- 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: 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.