Microsoft Excel 2021365 - Beginner to Advanced - Data Tables: Two Variables

This video tutorial explains how to create a two-variable data table in Excel, focusing on calculating monthly payments based on interest rates and loan amounts. It begins with an introduction to the concept, followed by a detailed setup of the PMT function to calculate payments. The tutorial then demonstrates how to build the data table by linking the PMT calculation and selecting the appropriate inputs. Finally, it covers formatting the table and verifying the accuracy of the calculations.

How do you convert the term of a loan from years to months in the calculations?

What steps are involved in formatting the results of the data table?