Loan Amortization in Spreadsheets

DataCamp
via DataCamp
Learn how to build an amortization dashboard in spreadsheets with financial and conditional formulas.
Save (0)
ClosePlease login

No account yet? Register

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(s)

Brent Allen
DataCamp
via DataCamp
Free Trial Available
English
4 Hours
Self paced