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.
Define scenarios using static values
From the course: Excel: Scenario Planning and Analysis
Define scenarios using static values
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.