How to create a Mortgage Spreadsheet. Excel crash course
3.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,270 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to create a Mortgage Spreadsheet. Excel crash course to your Wishlist.

Add to Wishlist

How to create a Mortgage Spreadsheet. Excel crash course

Simple and Fun Excel crash course based on Mortgage payments that you will never be able to live with out!
3.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,270 students enrolled
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 32 mins on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use the PMT and IPMT function and carry out other useful exercises in Excel. The student will be able to build a great spreadsheet based on a Mortgage.
  • Progress onto more advanced courses in Excel
  • Be able to work with the principles of Excel
View Curriculum
Requirements
  • All skill levels welcome and all versions of Excel are compatible with this course.
Description

Hi,

Did you know that 750 million people have Excel installed on their computer but most do not know how to use it!

But in this free course I will talk you through building a basic spreadsheet based on Mortgage repayments (Something on most peoples minds.....or eventually will be). I will demonstrate the PMT function (Payment function) to find the exact payments that should be made on a specific mortgage (Or Mortgage of your choice). Then later in the course I will delve into the world of interest when I will show you the IPMT function (Interest payment). Whooooohooooo! 

Let's just say that mortgages can be a little stressful at best, but let Excel do all of the work in this free course. Just follow along throughout my lectures and learn some fantastic features and functions that you will never be able to live without....in this world that revolves around CREDIT!

Warrick 

   

Who is the target audience?
  • Any person who would like to take part in a quick but useful lesson on how to build a spreadsheet on Mortgages!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Part 1
6 Lectures 32:18

Please download this Excel Spreadsheet for the course. Thank you

Preview 08:43


Mortgages Part 2: Getting to know the PMT Function
05:15

Mortgages Part 3: Numbers time!
02:01

Mortgages Part 4: Introduction to the IPMT (Yearly Payments)
06:34

Mortgages Part 5 (Monthly Payments)
05:06
About the Instructor
Mr Warrick Klimaytys
4.7 Average rating
43 Reviews
2,460 Students
5 Courses
Computer Technician at Udemy

Hi! My name is Warrick. After qualifying and spending many years with all kinds of computers in many different situations all around the world, I thought it would be a fantastic opportunity to share my knowledge and skills with the Udemy community.

Around  a decade ago I started my professional life in the military where I had experience with all kinds of computers and machines. Today I could be referred to as just a Microsoft "Windows Warrior". As a result of my past experience, I find it is best to deliver my lessons in bite sized chunks and though I try and stay one step ahead of Technology, I find it is always best to walk side by side with my students.