Microsoft® Office Excel 2003: Level 3

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 and 2. In addition, Web browsing experience is strongly recommended.

Course Content

Lesson 1: Creating and Applying Templates

Create a Workbook from a Template

Create a Custom Template

Lesson 2: Creating and Modifying Charts

Create a Chart

Format Chart Items

Change the Chart Type

Create a Diagram

Create a Trendline

Lesson 3: Working with Graphic Objects

Insert Graphics

Create AutoShapes

Format Graphic Objects

Change the Order of Graphic Objects

Group Graphic Objects

Move, Copy, and Resize Graphic Objects

Lesson 4: Using Advanced Functions

Calculate with Financial Functions

Calculate with Statistical Functions

Calculate with Lookup and Reference Functions

Calculate with Logical Functions

Lesson 5: Using Goal Seek

Edit a formula result using Goal Seek

Lesson 6: Using Database Functions

Calculate with Database Functions

Lesson 7: Auditing Worksheets

Trace Cell Precedents

Trace Cell Dependents

Locate Errors in Formulas

Locate Invalid Data and Formulas

Group and Outline Data

Lesson 8: Working with Multiple Workbooks

Create a Workspace

Link Cells in Different Workbooks

Edit Links

Return to Table of Contents