Artificial Intelligence & Data Science
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Loan Amortization in Spreadsheets

Course Cover
compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

It seems that only financial traders and bankers would use the loan amortization schedule. Wrong! This course will explain the financial formulas that you can use in Google Sheets for your loan analysis. These can be student loans, auto loans, car loans, mortgages and car loans. We'll make a Google Sheets dashboard to impress finance managers. It uses visualizations, conditional calculations and other tools to create presentation-ready spreadsheets.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Financial Modeling in Spreadsheets

What You Will Learn

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

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

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!

Course Instructors

Author Image

Brent Allen

Financial Spreadsheets Specialist

Brent has held a wide variety of roles across a wide array of businesses ranging from world-class banking institutions to local real estate companies. With over 20 years of experience in spreadsheets...
Course Cover