This finance video tutorial explains how to create an amortization table in excel. In this article, we will introduce you to five Excel functions that make it easy to create an amortization schedule to track our monthly payment.Use these calculator templates to help you navigate your loans, budgets, net worth, and more. Enter your desired payment and let us calculate your loan amount. Or, enter in the loan amount and we will calculate your monthly payment. Free template with formulas.