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 ...

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.