[Free Excel Tutorial] HOW TO USE AN EXCEL DATA TABLE FOR 'WHAT IF' ANALYSIS - Full HD
[Free Excel Tutorial] HOW TO USE AN EXCEL DATA TABLE FOR 'WHAT IF' ANALYSIS - Full HD
To illustrate their use, we'll add one to the simple mortgage calculator shown below. As is, you can change any of the input values to change the results. (It's generally a good practice to separate input and result cells.) We won't spend any time on building the calculator. You can download the demo workbook or refer to Table A for the formulas. The IFERROR() function isn't necessary, but consider using it if you plan to distribute the workbook to others. This function is new to Excel 2007; Excel 2003 users can use ISERROR() to inhibit errors.
Now, let's suppose you want to compare changing interest rates - that's where a data table comes in. First, enter the data table's labels. They should be easy to glean from the result cells in your original sheet. In addition, the data table's first column should contain your variable. In this case, that's the changing interest rate. I used AutoFill to create this list. If you use formulas in the data table's first column, be sure to paste with values - data tables can't use formulas in the first column.
With the PMT function, you are able to calculate the monthly payment for a loan, based on an interest rate, number of periods and the amount of the loan. If you adjust the rate, periods or amount, the formula result changes, so you can see the effect of these different variables.
Free Excel Tutorial, HOW TO USE AN EXCEL DATA TABLE FOR 'WHAT IF' ANALYSIS, Full HD
Free Tutorial, HOW TO USE, EXCEL DATA TABLE FOR 'WHAT IF' ANALYSIS, Full, HD
Excel Tutorial, HOW TO USE,EXCEL DATA TABLE, 'WHAT IF' ANALYSIS
This video [Free Excel Tutorial] HOW TO USE AN EXCEL DATA TABLE FOR 'WHAT IF' ANALYSIS - Full HD is copyrighted for Rui Ludovino channel: • [Free Excel Tutorial] HOW TO USE AN EXCEL ...