Plan payments and savings in Excel 2010

• • 
  • 2:50
  • Figure out your finances, starting with credit card debt
• • 
  • 2:45
  • Figure out mortgage payments
• • 
  • 1:25
  • Figure out savings for a vacation
• • 
  • 1:26
  • See how a starting deposit affects savings
• • 
  • 1:20
  • Figure out a down payment
• • 
  • 1:41
  • How long will it take to pay off a personal loan?
• • 
  • 1:11
  • Figure out how much your savings will add up to over time

Learn how to figure out payments and savings by using formulas in Excel.

Goals

After completing this course you will be able to:

• Figure out the monthly payments to pay off a credit card debt.

• Figure out monthly mortgage payments.

• Find out how much to save each month for a dream vacation.

• Find out long it will take to pay off a personal loan.

• Figure out a down payment.

• See how much your savings will add up to over time

Before you begin

You should already be familiar with Excel formulas. If not, take Get to know Excel 2010: Create formulas before taking this course.

Download this course

Offline Version (17 MB)

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses on Microsoft Office Training.