Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Plan payments and savings by using financial formulas 
 
  Overview  
 Show/Hide lesson sections Figure out monthly payments
 Show/Hide lesson sections Figure out savings and down payments
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
Use financial formulas to plan payments and savings  

Learn how to use Microsoft® Excel formulas to figure out payments, savings, and other financial numbers.

  • Length: 40–50 minutes
  

Next

GOALS

After completing this course you will be able to use formulas to figure out:

  • How much you would need to spend on monthly payments such as mortgage or car payments.
  • How much you would need to save in order to accumulate a specific amount by a certain point in time.
  • How much of a down payment you would need to make, for monthly payments to equal a particular amount.
  • How much you would gain over time on a specific amount of savings.
  
ABOUT THIS COURSE

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
COURSE TEXT

How much will you need each month for your mortgage or car payment? How much could you save by paying off a credit card balance in two years instead of four years? How much should you save each month, and how long would it take, to pay for college tuition or a vacation? How much could you gain on your savings over a period of time? In this course you'll learn how Excel formulas can quickly figure out what you must pay and what you need to save.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

  
BEFORE YOU BEGIN

You should complete the course Audio course: Get to know Excel: Enter formulas, or you should already be familiar with Excel formulas, functions, cell references, and function arguments.
  Go to previous page (disabled)    Next Go to next page
advertisement