Description

Excel: How to create a spreadsheet on car finance

Excel: How to create a spreadsheet on car financeMP4 | Video: AVC 1280×720 | Audio: AAC 44KHz 2ch | Duration: 40M | Lec: 7 | 118 MB Genre: eLearning | Language: English
Learn to crunch figures ‘Excel style’ and see how affordable a car or anything else could be!
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).

In this course I will show you how to build a basic car finance spreadsheet using Excel.

We will use formulas and functions such as Vlookup, Pmt, Rate and Bargainrate.

With these methods we can compare how much different interest rates could change the monthly payment amount and cost of ownership

. In addition, we´ll create charts to visualize the information in a more understandable way.

If you want to learn how to use Excel to work out the cost of buying a car and also how

to get maximum value for money with your next purchase, then this course is for you.

In this free course, I will talk you through how to create a spreadsheet in Excel.

This course is aimed at anyone who wants to learn how to use spreadsheets but has no prior experience.

Ever wondered how to build a spreadsheet in Excel? In this course I’ll show you.

No previous knowledge is required as we go through all the steps together.

This course is designed to take you into how

Excel works and some basic formulas, so you can create your own spreadsheets for projects or personal use.

Whether you’re a complete beginner or have used Excel before, there’s something here for everyone!

Learn how to create and use a spreadsheet in MS Excel.

Find out how to record and use data, build formulas and functions, analyse information and produce charts. No prior knowledge of Excel required.