Create a Mortgage Calculator in Excel

提供方
Coursera Project Network
在此指導項目中,您將:

Create a mortgage payment calculator in an Excel Spreadsheet, using the function PMT, IMPT and PPMT.

Clock1.5 hours
Beginner初級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

By the end of this project, you will learn how to create a mortgage payment calculator in an Excel Spreadsheet by using a free version of Microsoft Office Excel. Excel is a spreadsheet that is similar in layout as accounting spreadsheets. It consists of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. While a mortgage calculator helps you to see how extra payments effect your principal amount. We will learn to create a budget both automatically and manually, step by step. By utilizing Microsoft Excel, you will reduce the burden of working with your lender to create an early payoff plan. It will allow you to create your own payment plan for your timeline.

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  1. Download Microsoft Office365 Excel Program and the go over the basic view of Excel

  2. Create a mortgage payment calculator in Excel from a blank spreadsheet

  3. Use the PMT Function

  4. Use the PPMT function

  5. Use the IPMT function

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心