Excel Video 339 introduces Scenario Summaries, a great way to see all of your scenarios in one place. Once you’ve built several scenarios, it’s easy to switch between each scenario. Today we’ll create a Scenario Summary where you can compare the results of each scenario.
Scenario Summaries are easy to create, but there’s a caveat. The Scenario Summary won’t change if you change the Scenario. I’ll walk through a couple of examples in Excel Video 339, but the key is that when I change the numbers, the Scenario Summary isn’t live. I have to create a new Scenario Summary to capture any changes. Stay tuned. Next time we’ll create a Pivot Table with the Scenario Summary.
