Loan Amortization in Spreadsheets
Updated on
Course overview
- Provider
- Datacamp
- Course type
- Free trial availiable
- Deadline
- Flexible
- Duration
- 4 hours
- Certificate
- Available on completion
- Course author
- Brent Allen
Description
Learn how to build an amortization dashboard in spreadsheets with financial and conditional formulas.
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!
Similar courses
-
30 hours
-
488 lessonsCertificate
-
21 hours
-
218 lessonsCertificate
-
English language
-
Recommended provider
-
Certificate available