New Horizons Computer Learning Center
410-597-9722

Excel 2003 - Level 2

Course Length: 1 Day

Overview:
In this course, students will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Prerequisites:
Excel 2003 - Level 1
Or equivalent knowledge

Course 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

• 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

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com