Create a Home Affordability Worksheet in Google Sheets

提供方
Coursera Project Network
在此免费指导项目中,您将:

You will learn a step-by-step approach to build a Google Sheets spreadsheet and add a doughnut chart.

You will learn to analyze data and learn SUM, PMT, MIN, and PV formulas to determine the home affordability.

Showcase this hands-on experience in an interview

Clock2 hours
Beginner面向初学者
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

During this project, we will be working together to create a home affordability worksheet in Google Sheets. You will learn how to create formulas to include interest rates on multiple debt items, and show the timeline it will take to payoff the debt. This is a great tool to use if you have plans to purchase a home in the future, and want to learn how much you can afford. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

必备条件

Familiarity of Google Sheets or a workbook system and a free Google email account is required for this project.

您要培养的技能

Financial ManagementFinancial Data AnalysisAccountingProblem SolvingData Analysis

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Create Google Sheets income and monthly debts

  2. Create Google Sheets monthly housing expenses

  3. Create Google Sheets available funds

  4. Create Google Sheets financing options

  5. Create Google Sheets home affordability chart

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心