DATA TABLE | QUICKLY CREATE A LARGE TABLE OF VALUES

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.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/pmt_DATA_TABLE.mp4′]