Calculating Payments in Excel
by David Wang
Preview
|
Full size
Buy lesson
Buy lesson
(only $0.99) |
You Might Also Like
-
Simple & Compound Interest 180 -
Simple Interest Formula & Maturity Value Formula -
Learn Excel Basics, Part 3 - Cell References -
Learn Excel Basics, Part 1 - Data Entry -
An Introduction to Excel -
Learn Excel Basics, Part 2 - Create Formulas -
Interior Design Basics - Add Style to Your Home -
Creating a Financial Report in Excel -
Creating Invisible Buttons in Flash -
Deleting Background Using Photoshop
-
Deleting Background Using Photoshop -
Creating Invisible Buttons in Flash -
Creating a Financial Report in Excel -
Interior Design Basics - Add Style to Your Home -
Learn Excel Basics, Part 2 - Create Formulas -
An Introduction to Excel -
Learn Excel Basics, Part 1 - Data Entry -
Learn Excel Basics, Part 3 - Cell References -
Simple Interest Formula & Maturity Value Formula -
Simple & Compound Interest 180 -
How to Manage Employees -
Create a Poster in Photoshop(Part 2) -
Create a Poster in Photoshop(Part 1) -
Learn to Draw in Adobe ILLUSTRATOR -
Interior Design Basics - Add Style to Your Home -
Creating a Financial Report in Excel -
Creating Invisible Buttons in Flash -
Deleting Background Using Photoshop -
How to Create Rounded Corners in Dreamweaver -
How To Manage Stress
-
How To Manage Stress -
How to Create Rounded Corners in Dreamweaver -
Deleting Background Using Photoshop -
Creating Invisible Buttons in Flash -
Creating a Financial Report in Excel -
Interior Design Basics - Add Style to Your Home -
Learn to Draw in Adobe ILLUSTRATOR -
Create a Poster in Photoshop(Part 1) -
Create a Poster in Photoshop(Part 2) -
How to Manage Employees
About this Lesson
- Type: Video Tutorial
- Length: 16:45
- Media: Video/mp4
- Posted: 03/23/2009
- Use: Watch Online & Download
- Download: MP4
- Size: 25 MB
Thinking about buying a car or house? In this course, you will learn how to calculate your payments and interest rates in Microsoft Excel. You will learn how to use the PMT formula to calculate the basic monthly payment, but this lesson also includes instruction on how to create an amortization schedule. You will learn the ipmt formula to calculate the interest payments. You will also learn how to use conditional formulas and a shortcut for absolute references. This lesson is extremely useful for budgeting your purchases. For the full Excel course and more, please visit Knowledgeocity.com
About this Author
-
- David Wang
- 25 lessons
- Joined:
03/05/2009
Knowledgeocity offers convenient and affordable online video training in a wide variety of categories and topics from business skills, computer software, finance, to lifestyle and many more. All courses are taught by university professors and certified industry experts to ensure the highest quality training videos. We offer ALL YOU CAN LEARN unlimited access to ALL training courses to fit anyone’s schedule and budget.
Check out our new website at: www.Knowledgeocity.com
More..Recent Reviews
This lesson has not been reviewed.
Please purchase the lesson to review.
Recent Comments
This lesson has not been reviewed.
Please purchase the lesson to review.
Buy Now and Start Learning
CommunityMore
- Painting with Acrylics: Layering Te...
-
- I am taking a class from Polly right now, and this lesson is a great way for me to unde...
- Trigonometry: Trig Function Composi...
-
- great explanation of trig function composition and inverse trig functions.
- Flower painting 1-Water Color Pencils
-
- Excellent, easy to follow instruction.
- I want to learn how to build a slid...
-
- I want to learn how to build a slideboard
- compound subjects and predicates
-
- compound subjects and predicates
- I want to learn Trigonometry
-
- I want to learn Trigonometry
Embed this video on your site
Copy and paste the following snippet:
Link to this page
Copy and paste the following snippet:
