Page 1 of 24PREVNEXT

Get to know Excel: Enter formulas

Use Excel as your calculator
Get to know Microsoft® Excel by learning how to perform simple calculations. Get started by learning to enter simple formulas into worksheets.

About this course

This course includes:

  • Three self-paced lessons and three practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Do math by typing simple formulas to add, divide, multiply, and subtract.
  • Use cell references in formulas, so that Excel can automatically update results when values change or when you copy formulas.
  • Use functions (prewritten formulas) to add up values, calculate averages, and find the smallest or largest value in a range of values.

After you try Excel, you'll never go back to a calculator. In this course you'll learn how to add, divide, multiply, and subtract by typing formulas into Excel worksheets. You'll also learn how to use simple formulas that automatically update their results when values change. If you need to revise a value after a total is calculated, no problem. Just make the change, and Excel updates the total for you.

To learn more about this course, you can read the overview in the center of this page or the detailed table of contents in the left column.

Click the Next button to start the first lesson.

Page 1 of 24PREVNEXT