Microsoft Office Excel 2007 On Demand

3. Working with Formulas and Functions

What You'll Do

Understand Formulas

Create and Edit Formulas

Understand Cell Referencing

Use Absolute Cell References

Use Mixed and 3-D Cell References

Use Labels for Cell References

Name Cells and Ranges

Enter and Manage Names

Simplify a Formula with Ranges

Display Calculations with the Status Bar

Calculate Totals with AutoSum

Perform One Time Calculations

Convert Formulas and Values

Correct Calculation Errors

Correct Formulas

Audit a Worksheet

Locate Circular References

Perform Calculations Using Functions

Create Functions and Nested Functions

Calculating Multiple Results

Introduction

Once you enter data in a worksheet, you'll want to add formulas to perform calculations. Microsoft Office Excel can help ...