Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Select the entire data table range and go to the Data tab, select What-If Analysis > Data Table. Specify the row and column input cells corresponding to the horizontal and vertical variables. Example: ...

An curved arrow pointing right. Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once. Follow BI Video ...

Use Data Table for what-if analysis. Old-school Excel came with a forecasting ability that looked at historical data and made forecasts with a high-low numeric range, ...

Click on “What-If Analysis” in the “Data Tools” group. Select “Scenario Manager” from the dropdown menu. In the Scenario Manager dialog box, click “Add” to create a new scenario.