
 7:59
 More about functions
Learn how to use formulas to do basic math in Excel, how to make formula results update automatically, and how to use predefined formulas called functions that do things like calculate the amount of monthly payments.
Goals
After completing this course you will be able to:

Use Excel to add, divide, multiply, or subtract.

Learn how to write formulas and use math operators so that Excel calculates them the right way.

Write formulas that can automatically update results when values change, or when you copy a formula to another location.

Know the different types of cell references and when to use them when you copy formulas: relative, absolute, and mixed.

Create formulas with functions to add numbers, calculate monthly payments, and capitalize proper names.
Download this course
Offline version (32 MB)
Practice
We’re sorry, the practice session is not available.
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.