Learn how to use data tables for what-if analysis and compare different valuation methods for a company, such as DCF, multiples, and DDM, in Excel.

Select Data Table from the drop-down menu and enter the cell reference of the input variables in the Row input cell box and Column input cell box. Finally, click OK and Excel will fill the range ...

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

You will notice that if you change in cells C1 or C3 the Data Table does not change. Only the cell B6 with the PMT formula in will show a different result. If on the other hand you increase or ...

table_array: This is the range of cells that contains your data. The VLOOKUP function looks for the lookup_value in the first column of this range. The data you’re working with is organized in this ...

Replicates the Excel "What-If Analysis" feature, Data Tables. In the future, I may add the other Excel features, e.g. Scenarios. This will try to create a data table from the currently-selected cell ...

We use cell I3 as the place to input the data, and tell the function that the relevant table runs from B2 to D11, and that the answers will be in the third column (vlookup reads from left to right).

In cell G4, I'll start with the INDEX function, as I want Excel to find and return a value from my raw data. Then, I'll tell ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...