In this video we're going to talk about how to create an amortization schedule. Fill in the "Period" column.Fill in the column titled "Period" with your payment dates. I'm going to show you how to build an amortization table in Excel from scratch. Today we're going to talk about how to build a simple amortization schedule you could use this to do a mortgage. This short video shows how to easily create a simple amortization table in Excel. 1. Download the amortization schedule from Microsoft. 2. Open the template in Excel. 3. Below are instructions for completing the calculator in Excel. Prepare annual audit schedules and interact with auditors to complete the audit, consolidation, and tax returns.