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

How to Use a Data Table. Follow the steps below to use a Data Table, the third What-If Analysis tool. Do note the data setup. For an example, we are using a Data Table to see how much our loan ...

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.

Notice that the pivot table is displaying only the data that’s pertinent to our present analysis. On the right-hand side, you’ll find the criteria that Excel used to create it in the ...