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.

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF