Video: Get to know Excel 2010 — Create formulas

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

Discover more Excel training at LinkedIn Learning

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.