Get to know Excel 2010: Create formulas

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.