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

Click the Data tab, click What-If Analysis, and then choose Goal Seek. In Excel 2003, choose Goal Seek from the Tools menu. In the resulting dialog, enter 50000 as the To value.

Excel what-if analysis data tables. An curved arrow pointing right. X LinkedIn Copy Link. The letter F. Sara Silverstein. 2015-04-21T13:35:00Z An curved arrow pointing right. X ...

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

The Data Analysis Toolpak provides a user-friendly interface that allows you to input your data and parameters, and then automatically generates the results in an output table.

Whichever method you use to create the table, Excel will open a new worksheet with the table in it. If you like, you can copy it into the original data sheet as I did in the screenshot.

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