How to Create a Loan Amoritization Schedule in Excel. Microsoft Excel allows you to either create a spreadsheet from scratch with your own formulas or use a premade template provided by Microsoft.