This finance video tutorial explains how to create an amortization table in excel. Keep track of your loan schedule and try this Loan Amortization Table Template.This is a great tool to use when looking at the financial impact of a loan. Create a Loan Amortization Schedule Excel Assignment For this assignment you are required to create two loan amortization schedules. Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft Excel Step 1: Set up your amortization table. Open a new Excel sheet and create input cells for the known components of your loan.