Microsoft Office 2010 On Demand

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

Calculate Totals with AutoSum

Correct Formulas

Create Functions and Nested Functions

Use Nested and Text Functions

Use Lookup and Reference Functions

Summarize Data using Subtotals and Functions

Convert Text to Columns

Create and Format a Table

Create Calculations in a Table

Remove Table Rows and Columns

Sort Data in a Table

Display Parts of a Table with AutoFilter

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