Excel: How to create a spreadsheet on car finance
0.0 (0 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.
743 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: How to create a spreadsheet on car finance to your Wishlist.

Add to Wishlist

Excel: How to create a spreadsheet on car finance

Learn to crunch figures 'Excel style' and see how affordable a car or anything else could be!
0.0 (0 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.
743 students enrolled
Last updated 2/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 40 mins on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build a clear representation of a car loan on a spreadsheet and get the exact cost of a car loan before signing the contract.
View Curriculum
Requirements
  • All skill levels welcome. Course is compatible with all versions of Excel.
  • This course can EASILY be applied to any type of finance....Motorcycle, Boat, jet, etc!
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 a car loan (Something on most peoples minds, when they get a whiff of new car smell). I will demonstrate the PMT function (Payment function) to find the exact payments that should be made on a specific car loan (Or car loan 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!.

By the end of the course you will know how to work out the EXACT cost of buying a car with a loan, once you have reached the end of your term of agreement and sell the car.

Let's just say that car loans can be a little stressful....and shady 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 extend their Excel skill set.
Compare to Other Excel Courses
Curriculum For This Course
+
Start Here
7 Lectures 40:03

Download this Excel Spreadsheet. Thank you.

Preview 08:43





Car loan Part 5
06:36

Car loan Part 6
06:28
About the Instructor
Mr Warrick Klimaytys
4.7 Average rating
46 Reviews
2,469 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.