Microsoft Excel 2002: Level 1

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 first 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:

 

   Windows XP Level 1           Windows XP Level

   Basic Typing Skills           Windows XP Introduction

 

Performance-Based Objectives

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

 

   Getting Started With Excel          Modifying a Worksheet

   Performing Calculations              Formatting a Worksheet

   Developing a Workbook              Customizing Layout

   Printing Workbook

Course Content

 

EL1-01: Getting Started With Excel

   An Overview of Excel

   Navigate in Excel Topic

   Select Data

   Enter Data

   Save a Workbook

   Obtain Help

 

E1-02: Modifying a Worksheet

   Move and Copy Data Between Cells

   Fill Cells with Series of Data

   Edit Cell Data

   Insert and Delete Cells, Columns, and Rows

   Find, Replace, and Go To Cell Data

   Spell Check a Worksheet

 

E1-03: Performing Calculations

   Create Basic Formulas

   Calculate with Functions

   Copy Formulas and Functions

   Create an Absolute Reference

 

EL1-04: Formatting a Worksheet

   Change Font Size and Type

   Add Borders and Color to Cells

   Change Column Width and

      Row Height

   Merge Cells

   Apply Number Formats

   Create a Custom Number Format

   Align Cell Contents

   Find and Replace Formats

   Apply an AutoFormat

   Apply Styles

 

EL1-05: Developing a Workbook

   Format Worksheet Tabs

   Reposition Worksheets in a

      Workbook

   Insert and Delete Worksheets

   Copy and Paste Worksheets

   Copy a Workbook

 

EL1-06: Printing Workbook

               Contents

   Format Worksheet Tabs

   Reposition Worksheets in a

      Workbook

   Insert and Delete Worksheets

   Copy and Paste Worksheets

   Copy a Workbook

 

EL1-07: Customizing Layout

   Split a Worksheet

   Arrange Worksheets

   Freeze and Unfreeze Rows

      and Columns

   Hide and Unhide Worksheets