Page 1 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Overview art
Get to know Microsoft Office Excel 2007 by learning how to enter formulas into worksheets and perform simple calculations. Then, ditch your calculator.

About this course

This course includes:

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


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.

Before you begin

If you want to know how to create a workbook, and how to enter and edit text and numbers, you need this course: Get to know Excel 2007: Create your first workbook.

If you are not familiar with the new look in Excel 2007, take this course: Up to speed with Excel 2007.

Excel is great for working with numbers and math. Sometimes you do that by entering formulas, and 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, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 24PREVNEXT