Selecting which scenario to display can be as simple as typing a number in a box, but you may prefer to click a down arrow and select a number from a list so you don’t have to type on the keyboard. In this video, learn how to create those controls using d
- [Instructor] Presenting your data as a series…of scenarios allows you to analyze possible…future outcomes within a worksheet.…Selecting which scenario to display can be…as simple as typing a number into a box,…but I prefer to click a down arrow…and select a number from a list…so I don't have to type on a keyboard.…In this move, I will show you how to create…those controls using data validation rules.…My sample file is Scenarios 0203.…You can find it in the chapter two folder…of your exercise files collection.…
This workbook shows the possible outcomes…of different revenue and a cost of goods sold scenarios…based on the codes that I have here in column J.…Scenario one is for poor performance going up to…number five which is excellent…and number six is custom.…So for example, this custom scenario which is shown…in cell C16 for basic would have sales 70%…of the base value $275,000 and then the percentages…for Advanced, Professional, and Enterprise up here…in columns D, E, and F respectively.…
The way that Excel calculates the revenue is…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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