Excel 2003: Level 2

Course Description

Overview:   Students will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Prerequisites:  Windows 2000 or Windows XP; Excel 2003: Level 1; or equivalent knowledge.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• create and apply templates.
• create and modify charts.
• work with graphic objects.
• calculate with advanced formulas.
• sort and filter data.
• use Excel with the Web.

 

Course Content

Lesson 1: Creating and Applying Templates

Create a Workbook from a Template

Create a Custom Template

Working with Comments

Create a Hyperlink

Use Web-based Research Tools

Lesson 2: Creating and Modifying Charts

Create a Chart

Format Chart Items

Change the Chart Type

Create a Diagram

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: Calculating with Advanced Formulas

Create and Apply a Name for Worksheet to the Web

Calculate Across Worksheets

Calculate with Date and Time Functions

Calculate with Financial Functions

Calculate with Statistical Functions

Calculate with Lookup and Reference Functions

Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data

Sort Data Lists

Filter Data Lists

Create and Apply Advanced Filters

Calculate with Database Functions

Add Subtotals to a Worksheet

Lesson 6: Using Excel with the Web

Export Excel Data

Publish a Worksheet to the Web

Import Data from the Web

Create a Web Query