Office 2008 for the Mac on Demand

Chapter 9. Building a Worksheet with Excel

What You’ll Do

Understand Formulas and Referencing

Create and Edit Formulas

Name Cells and Ranges

Enter and Manage Names

Simplify a Formula with Ranges

Use Calculator and Formula Builder

Use Nested and Text Functions

Calculate Multiple Results

Use Lookup and Reference Functions

Summarize Data using Subtotals and Functions

Calculate Totals with AutoSum

Create and Format a List

Create Calculations in a List

Remove List Rows and Columns

Sort Data in a List

Display Parts of a List with AutoFilter

Convert Text to Columns

Create Groups and Outlines

Add Data Validation to a Worksheet

Create a Drop-Down List

Introduction

Once you enter data in a worksheet, you’ll want to add formulas to perform calculations. ...