Sensitivity analysis with Data Tables
Data Tables are a great tool for What-If analysis. Similar to the Scenario Summary, they create a table with the results of the inputs; however, it does this in a much easier way.
Bananas wants to keep exploring their pricing strategy, and they're curious about how Premium
sales would be impacted at various levels of prices and demand. The Data Table is the perfect tool for this.
If you've lost progress, open up 3_3_scenario_manager.xlsx
from the Workbooks
folder.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
