Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

A budget in a worksheet needs an amount in cell C6.

Imagine that Excel is open and you're looking at the "Entertainment" section of a budget for household expenses. Cell C6 in the worksheet is empty; the amount spent for CDs (compact discs) in February hasn't been entered yet.

In this lesson you'll learn how to use Excel to do basic math by typing simple formulas into cells. You'll also learn how to total all the values in a column with a formula that updates its result if values change later on. In the practice session at the end of the lesson, you'll have a chance to use the formulas you've learned about. You'll need Excel 2007 to do the practice steps.