This course teaches learners how to calculate simple interest and work with short-term loans using Excel. The learning outcomes include understanding debt, interest, and mastering simple interest calculations. Students will learn simple interest formulas and how to calculate interest for different time periods. The course uses video examples to demonstrate solving for principal, annual interest rate, and time. The intended audience for this course is individuals interested in Excel, business math, and financial calculations.
Overview
Syllabus
) Introduction.
) What is Debt?.
) What is Interest?.
) Simple Interest Terms & Example #1 of Simple Interest.
) Simple Interest Formulas.
) Video Examples 02-04, Calculate Simple Interest when Time is Given as a Fraction of Year.
) Video Examples 05-08, Calculate Simple Interest when Time is Given in Days or Months.
) Video Examples 09-10, Solve for Principal.
) Video Examples 11-12, Solve for Annual Simple Interest Rate.
) Video Examples 13-14, Solve for Time.
) Summary.
Taught by
ExcelIsFun
Related Courses
-
Excel and Business Math - Compound Interest Calculating Future Value of a Lump Sum FV Excel Function
-
Everyday Excel, Part 2
-
Highline Excel 2016 Class - Financial Functions: PMT, RATE, NPER and FV Examples
-
Mastering Excel Essentials to Enhance Business Value
-
Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction
-
Excel & Business Math - Five Steps to Solve Math Word Problems in Excel
