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.

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

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals. If you ask me, Excel’s what-if analysis tools are under-used. I often respond to ...

So in this guide, I’ll introduce you to Excel’s what-if analysis tools: Goal Seek; Scenario Manager; Data Table; We’ll review the options, discuss when to use them, and then implement all ...