Watch Excel Video 340 today to see two more tricks with Scenarios. You may never hear PivotTableGuy say this again, but I actually like the Scenario Summary better. Both the Summary and the Pivot Table take some renaming like we did in Excel Video 339, but the Summary seems easier to read.
The other thing to watch for in Excel Video 340 is how to merge Scenarios. If multiple people are contributing to a project, or if you have Scenarios on your laptop and on your desktop, here’s how to merge Scenarios. Once the Scenarios are merged, rerun the Summary and you can see all of the Scenarios in one place.
Now that we’ve covered Scenarios, stay tuned. Data Tables are coming up next.
