|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| PMT FUNCTION | MORTGAGE REPAYMENT CALCULATOR- 2012-10-23 05:29:51-04 |
In today’s tutorial we are going to look at how to use the PMT function in Excel to calculate mortgage repayments. In another post, I’m going to show you how to use the PMT function with another Excel feature (called Data Tables) to very quickly generate a table of values. Essentially there are 3 main [...]
Read more...
|
| DATA TABLE | QUICKLY CREATE A LARGE TABLE OF VALUES- 2012-10-23 05:40:38-04 |
In this blog posting, I’m going to show you how to use a feature in Excel to create a large table of values. The feature is called Data Tables and I’m going to use the PMT function with it to show you how to quickly create a large table of loan repayment values. Here is [...]
Read more...
|
|