Page 2 of 24PREVNEXT

Get to know Excel: Enter formulas

Worksheet with entertainment expenses

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

In this lesson you'll learn how to use Excel as your calculator 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.

When you've finished reading this page, click the Next button to continue the lesson on your own.


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.

Page 2 of 24PREVNEXT