Microsoft Excel 2002: Level 3

Course Specifications

Software Version: Excel 2002

Course Length: 6 Hours

 

Course Description

Spreadsheets are used to create, revise, and save documents for printing and future retrieval. This course is the third in a series of three Microsoft Excel 2002 courses. It will provide you with the basic concepts required to produce basic spreadsheets.

 

Prerequisites

You should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. One of the following courses or equivalent knowledge is required:

 

   Basic Typing Skills         Windows XP Introduction

   Windows XP Level 1 & 2         Excel Level 1 & 2

 

Performance-Based Objectives

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

   Financial Functions       Data Tables      Amortization Schedules         Hyperlinks       Print Settings         Cell Protection

   Formula Checking Features       Creating A Worksheet Database

   Sorting A Worksheet Database        Querying A Worksheet Database         Creating Templates

   Working With Multiple Worksheets And Workbooks

 

Course Content

EL3-01: Financial Functions

   Control The Color And Thickness Of Outlines And Borders Assign A Name To A Cell And Refer To The Cell

   Determine The Monthly Payment Of A Loan Using The Financial Function PMT

 

EL3-02: Data Tables

   Create a data table to analyze data in a worksheet

   Add a pointer to a data table

 

EL3-03: Amortization Schedules

   Create An Amortization Schedule

   Determine A Present Value Of A Loan Using The PV Function

   Analyze Worksheet Data By Changing Values

 

EL3-04: Hyperlinks

   Add A Hyperlink To A Worksheet Element

 

EL3-05: Print Settings

   Use Names And The Set Print Area Command To Print Sections Of A Worksheet

   Set Print Options

 

EL3-06: Cell Protection

   Protect And Unprotect Cells In A Worksheet

 

EL3-07: Formula Checking Features

   Use The Formula Checking Features Of Excel

 

EL3-08: Creating a Worksheet Database

   Add Computational Fields To A Database

   Use The VLOOKUP Function To Look Up A Value In A Table

   Change The Range Assigned To A Named Database

   Use A Data Form To Display Records, Add Records, Delete Records, And Change Field  Values In A Worksheet Database

 

EL3-09: Sorting A Worksheet Database

   Sort A Worksheet Database On One Field Or Multiple Fields

   Display Automatic Subtotals

 

EL3-10: Querying A Worksheet Database

   Use A Data Form To Find Records That Meets Comparison Criteria

   Filter Data To Display Records That Meet Comparison Criteria

   Use The Advanced Filtering Features To Display Records That Meet Comparison Criteria

   Apply Database Functions To Generate Information About A Worksheet Database

   Print A Database

 

EL3-11: Creating Templates

   Create And Use A Template

   Utilize Custom Format Codes

   Define, Apply, And Remove A Style

 

EL3-12: Working With Multiple Worksheets and Workbooks

   Add A Worksheet To A Workbook

   Create Formulas That Use 3-D References

   Consolidate Data Within The Same Workbook

   Draw A 3-D   Cylinder Chart

   Use WordArt To Create A Title

   Create And Modify Lines And Subjects

   Add Comments To Cells

   Add A Header And/Or Footer To A Workbook

   Change The Page Margins

   Insert A page Break

   Use The Find And Replace Commands

   Search For Files On Disk And Hard Drive

   Create And Use A Workspace File

   Consolidate Data By Linking Workbooks