CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEX032 - Microsoft Office Excel 2003 Level 2

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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

Prerequisites

Course APEX031: Microsoft Office Excel 2003 Level 1 or equivalent knowledge

Detailed Class Syllabus

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 a Range of Cells

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