Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Financial analysts, accountants, students, and many others are often tasked with creating an amortization schedule. However, not everyone has been taught the proper way to build one from scratch. In this step by step course, I will walk you though building your very own amortization schedule in Microsoft Excel from scratch. The course is packed with information that will help you answer popular questions relating to loans and mortgages.
This course is designed for the beginner Excel user, however the information moves fast enough to keep the attention of more experienced users.
This course is pretty quick, and should be completed in just 30 minutes.
If you want to learn how to calculate a car loan or mortgage, and build an amortization schedule, this course is for your.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Start Here|
This is the course introduction. This lecture explains what an amortization schedule is, and why someone would need this information. This video also explains the course objectives.
Building the table
Building the Table - Continued
Building the Table - Final
|Section 2: Putting it All Together|
Scenario 1- Description
Scenario 1 - Calculation
Scenario 2 - Description
Scenario 2 - Calculation
Scenario 3 - Description
Scenario 3 - Calculation
Scenario 4 - Description
Scenario 4 - Calculation
James has nearly twenty years experience using Microsoft Excel. He is experienced in the field of investment management and corporate finance. James' uses his vast experience to help others learn Microsoft Excel, and apply their learning to real-world problems. His conversational teaching style is a great fit for the beginner or intermediate user.