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 the file for you to practise on.
Here is the video.