Clear Canyon Technologies Software Training

Microsoft® Office Excel 2003: Level 2

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

Course Prerequisites
To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Completion of:

• Microsoft Excel 2003: Level 1

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.

Course Content

Lesson 1: Creating and Applying Templates
Topic 1A: Create a Workbook from a Template
Topic 1B: Create a Custom Template
Topic 1C: Working with Comments
Topic 1D: Create a Hyperlink

Lesson 2: Creating and Modifying Charts
Topic 2A: Create a Chart
Topic 2B: Format Chart Items
Topic 2C: Change the Chart Type
Topic 2D: Create a Diagram

Lesson 3: Working with Graphic Objects
Topic 3A: Insert Graphics
Topic 3B: Create AutoShapes
Topic 3C: Format Graphic Objects
Topic 3D: Change the Order of Graphic Objects
Topic 3E: Group Graphic Objects
Topic 3F: Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with Advanced Formulas
Topic 4A: Create and Apply a Name for a Range of Cells
Topic 4B: Calculate Across Worksheets
Topic 4C: Calculate with Date and Time Functions
Topic 4D: Calculate with Financial Functions
Topic 4E: Calculate with Statistical Functions
Topic 4F: Calculate with Lookup and Reference Functions
Topic 4G: Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data
Topic 5A: Sort Data Lists
Topic 5B: Filter Data Lists
Topic 5C: Create and Apply Advanced Filters
Topic 5D: Calculate with Database Functions
Topic 5E: Add Subtotals to a Worksheet

   Download .pdf version of this class description...