O'Reilly logo

Office 2008 for the Mac on Demand by Steve Perspection, Inc. Johnson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required