This finance video tutorial explains how to create an amortization table in excel. Step 1: Set up your amortization table.Open a new Excel sheet and create input cells for the known components of your loan. Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft Excel If you have reached age 73, you must take required minimum distributions from your IRA. Use this table as a guide.