Excel Lesson 04: Using Data Tables and Goal Seek in Microsoft Excel

This video will help you learn how to create and use data tables and how to use the goal seek tool in Microsoft Excel. Topics covered in this lesson include using the payment (PMT) function, creating a two-dimensional (two-variable) data table, and using the goal seek tool in Excel. You may jump to any of these topics by using the links below:

1. Using the payment (PMT) function: (1:44)
2. Creating a two-dimensional data table: (6:47)
3. Using the goal seek tool: (11:35)

[michaelwhittier]

Quick question! Why is PV for a loan negative (5:10)? I have always been taught that for loans the PV is positive because the balance in your bank account increases, which results in a negative payment each month (representing money leaving your account). For investments, the inverse is true (money is leaving your account initially, with the understanding that FV will then be positive at the end of the investment period).

Is the monthly payment paid on the beginning of each month or at the end of it?

[mickp]

Thanks for creating this. Very useful.

[AlexDubon]

Great video, as Thanks a lot! Quick question, what software do you use to record your computer screen and voice? Please respond, thank you.

[kristyfinley]

So, lets say I bought a car for 67, 500 less rebate of 375 with a down payment $3000 at 8% interest for 4 years. How would I figure out what my monthly pmt is. Lets say I can afford a $950 payment, how much would I have to put for a down payment in this same case scenario? Can you help?

[AlyssaManiago]

every time you said a word with an s, it hurt my ears