From the course: Excel: Scenario Planning and Analysis

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Select scenarios using data validation rules

Select scenarios using data validation rules

From the course: Excel: Scenario Planning and Analysis

Start my 1-month free trial

Select scenarios using data validation rules

“

- [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…

Contents