Show Me Microsoft® Office Excel 2003

Chapter 3. Working with Formulas and Functions

What You'll Do

• Create a Simple Formula

• Edit a Formula

• Understand Cell Referencing

• Use Absolute Cell References

• Use Labels for Cell References

• Name Cells and Ranges

• Simplify a Formula with Ranges

• Display Calculations with AutoCalculate

• Calculate Totals with AutoSum

• Correct Calculation Errors

• Correct Formulas

• Audit a Worksheet

• Perform Calculations Using Functions

• Create Functions

Introduction

Once you enter data in a worksheet, you'll want to add formulas to perform calculations. Microsoft Office Excel 2003 can help you get the results you need. Formulas can be very basic entries to more complex ones. The difficulty of the formula depends on the complexity of the result you want from your data. For instance, if you ...