Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise