Utilization of Data Table Formulas with the Excel 10


show more Using data tables in formulas provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Using data tables in formulas

Two Trees is considering a capital loan so that they can expand production by buying some capital equipment. But they want to see a whole bunch of options for how much this loan is going to cost them depending upon how long it takes them to pay back or maybe how much money they borrow. If you watch the movie on Goal Seek, you saw that we were able to substitute one input, maybe just the interest rate or maybe just the amount that they are borrowing. Well, using the Data Table feature we can substitute one or possibly two entire range of inputs.

In this workbook, you want to be in a single variable worksheet. Let's take a look at what we are doing here. We have about $100,000 that we are going to borrow. The company thinks that the interest rate will be about 6% per year. It's thinking of paying it off over a period of 10 years. We'll use the Payment function for that. If you click on the syntax tab, you can see the syntax of the Payment function. So, we see =PMT. What's the i...

Using data tables in formulas
Video duration: 6m 2s 6h 21m Beginner

Viewers:

Using data tables in formulas provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...