Using the NPER function to Calculate Payments Left to Finish a Loan in Microsoft Excel
Lets learn how to calculate how many payments would be left to finish a loan with the NPER function, or Number of Periods Function! Not only can we use this to learn how many payments are left, we can determine how many payments would be left if we changed the payment amount.
Have any questions about Microsoft Excel? Let us know your question, and it might be in our next video!
2
views
How to Use the PV Function in Microsoft Excel
What if someone promised to give you 1,000 dollars three years from now? How much is that actually worth today? Lets use the PV function to figure that out!
Have any questions about Microsoft Excel? Let us know and your question might be in our next video!
2
views
How to Install Microsoft PowerToys
Microsoft Power Toys is a fun tool that allows the user to utilize several different powerful shortcuts and utilities. In todays video, we will go over how to install Power Toys, and several upcoming videos we will go over the different shortcuts and what they do.
Have additional questions about Microsoft Power Toys, or Microsoft Excel? Ask them in the comments below and your question may be the subject of our next video!
PowerToys Link: https://learn.microsoft.com/en-us/windows/powertoys/
3
views
Microsoft Excel, The PMT Function: Payment on a Loan
The PMT function has several different excellent uses when working in a spreadsheet. Today however, we will be learning how to calculate a payment on a loan using PMT. This function works the same way for both Microsoft Excel and Google Sheets.
Do you have questions about Excel? Ask in the comments below, and our next video might answer your question!
Interested in longer format projects in Excel? Let us know what you would like to see us build out!
12
views
Calculating Interest Rates on Existing Loans with the Rate Function in Microsoft Excel
Lets figure out some interest rates with the RATE function! This function is used to figure out the interest rate on an existing loan, or to calculate the interest rate you would need if you knew the amount you were going to borrow, and what payments you wanted.
Have some Microsoft Excel questions? Ask below and our next video might just answer some of your questions!
6
views
Using Microsoft Excel to Find the Future Value of An Investment
Today we learn about the Future Value function! Use this function to calculate the future value of an investment assuming a given interest rate and regular payments into the investment of the same amount.
Have questions about Excel? Ask below and our next video might be to answer your question!
5
views