Microsoft® Office Excel 2003: Level 4

Course length: 1.0 day(s)

Prerequisites

To ensure your success, we recommend you first take the following PC University courses or have equivalent knowledge: Microsoft® Office Excel 2003: Level 1 Microsoft® Office Excel 2003: Level 2, and Microsoft® Office Excel 2003: Level 3.

Course Content

Lesson 1: Using Conditional Formatting

Apply Conditional Formatting

Adding Additional Conditions

Removing a Condition

Lesson: 2: Using Data Validation

Add Data Validation Criteria

Adding Data Validation Help Text

Modify Excel's Default Settings

Lesson 3: Collaborating with Others

Set Revision Tracking

Review Tracked Revisions

Working with Comments

Merge Workbooks

Lesson 4: Analyzing Data

Create Scenarios

Perform What-If Analysis

Lesson 5: Pivot Tables

Develop a PivotTable© Report

Develop a PivotChart© Report

Lesson 6: Creating Custom Toolbars

Create Custom Toolbars

Lesson 7: Streamlining Workflow

Create a Macro

Edit a Macro

Assign a Macro to a Tollbar Button

Lesson 8: Importing and Exporting Data

Export to Microsoft Word

Import a Word Table

Import Text Files

Create a Custom Number Format

Align Cell Contents

Find and Replace Formats

Apply an AutoFormat

Apply Styles

Merge Cells

Lesson 9: Working with Hyperlinks

Create a Hyperlink to another file

Create a Hyperlink within the spreadsheet

Create a Hyperlink to a Web Site

Edit a Hyperlink

Remove a Hyperlink

Return to Table of Contents