Microsoft® Office Excel 2003: Level 2

Course length: 1.0 day(s)

Prerequisites

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking the following PC University course: Microsoft Excel 2003: Level 1. In addition, Web browsing experience is strongly recommended.

Course Content

Lesson 1: Developing a Workbook

Format Worksheet Tabs

Renaming Worksheet Tabs

Reposition Worksheets in a Workbook

Insert and Delete Worksheets

Copy and Paste Worksheets

Navigating Multiple Worksheets

Arrange Worksheets

Lesson 2: Creating and Using Range Names

Viewing a Named Range

Creating a Named Range

Jumping to a Named Range

Using Named Ranges in Formulas

Lesson 3: Creating 3D Formulas to Calculate Across Multiple Worksheets

Creating a 3D Formula

Editing a 3D Formula

Using Functions in 3D Formulas

Using Range Names in 3D Formulas

Lesson 4: Calculating with Advanced Formulas

Using the Today Function

Using the Now Function

Calculate with Date Functions

Lesson 5: Sorting and Filtering Data

Sort Data Lists

Filter Data Lists

Using Criteria Ranges

Create and Apply Advanced Filters

Lesson 6: Using Subtotals

Add Subtotals to a Worksheet

Add Subtotals to a Filtered Worksheet

Creating a Subtotal Function

Lesson 7: Protecting Worksheets and Workbooks

Protect a Worksheet

Unprotect a Worksheet

Protect a Workbook

Unprotect a Workbook

Lesson 8: Working with Large Worksheets

Split a Worksheet

Freeze and Unfreeze Rows and Columns

Find, Replace, and Go To Cell Data

Return to Table of Contents