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.