Get to know Excel 2010: Create formulas

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.


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)


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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!