Loan Amortization in Spreadsheets

Course Cover

5

(3)

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.

blur
blur

Highlights

blur

Rating & Reviews

Top 30 Percentile

blur

Pedagogy

Top 20 Percentile

blur

Parameters

cv-icon

Pedagogy

Acquire all major Data Analytics skills in this course for seamless integration into your daily life. Develop a versatile skill set, allowing you to confidently apply what you've learned in various practical scenarios, enhancing your daily experiences and overall proficiency. An exceptional course in Data Analytics, this stands out for its Self Paced learning approach. Learners have the flexibility to progress at their own speed, tailoring the experience to their individual needs.

cv-icon

Rating & Reviews

This highly acclaimed course is among the top-rated in Data Analytics, boasting a rating greater than 4 and an overall rating of 5.0. Its exceptional quality sets it apart, making it an excellent choice for individuals seeking top-notch learning experience in Data Analytics.

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

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

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!

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 Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover