Page 1 of 9PREVNEXT

Get to know Excel 2010: Create formulas

Judi Hurlock

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.
By Judi Hurlock, Senior Writer

Applies to:

Offline version (32 MB)

About this course

This course includes:

  • One self-paced lesson.
  • One practice session for hands-on experience. The practice requires Excel 2010.
  • A short test at the end of the lesson. The test is not scored.
  • A Quick Reference Card you can print at the end of the course.


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.
Page 1 of 9PREVNEXT