Loan Amortization in Spreadsheets

Learn how to build an amortization dashboard in spreadsheets with financial and conditional formulas.

SKU: 2bfa0590a255


A loan amortization schedule sounds like something that’s only used by bankers and financial traders, right? Wrong! In this course, we’ll be looking at the key financial formulas in Google Sheets that you can use to investigate your own loans, like student loans, car loans, and mortgages. We’ll build up a dashboard in Google Sheets which uses visualizations and conditional formulas to produce presentation-ready spreadsheets which will impress any finance manager!

Instructor: Brent Allen