Excel 2002:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows 2000 Professional: Basic, or equivalent experience

Unit 1 : Excel basics

Topic A: 0 Spreadsheet terminology

A-1: Discussing spreadsheet terminology

Topic B: 0 Exploring the Excel window

B-1: Starting Excel

B-2: Showing or hiding the Office Assistant

B-3: Examining Excel window components

Topic C: 0 Getting help

C-1: Using the Ask a Question box

C-2: Working with the Office Assistant

C-3: Examining the Help database

Topic D: 0 Opening and navigating workbooks

D-1: Opening a workbook

D-2: Navigating a worksheet

Topic E: 0 Closing workbooks

E-1: Closing a workbook and Excel

Unit 2 : Entering and editing data

Topic A: 0 Creating workbooks

A-1: Creating a default Excel workbook

Topic B: 0 Entering and editing labels and values

B-1: Entering labels and values

B-2: Editing labels and values

Topic C: 0 Entering and editing formulas

C-1: Entering a formula by typing

C-2: Using the mouse to enter cell references

C-3: Editing a formula

C-4: Using Undo and Redo

C-5: Finding and replacing a formula

Topic D: 0 Saving and updating workbooks

D-1: Saving a workbook

D-2: Changing and updating a workbook

Unit 3 : Modifying a worksheet

Topic A: 0 Moving and copying data

A-1: Moving data by using the Edit menu

A-2: Moving data by using the Standard toolbar

A-3: Copying data in a worksheet

A-4: Moving data by using the drag-and-drop method

A-5: Copying data by using the drag-and-drop method

A-6: Copying data by using the Clipboard

Topic B: 0 Moving and copying formulas

B-1: Using shortcut menus to move formulas

B-2: Copying formulas

B-3: Using the fill handle to copy formulas

Topic C: 0 Using absolute references

C-1: Observing the limitations of relative references

C-2: Using absolute references

Topic D: 0 Inserting and deleting ranges

D-1: Inserting a range

D-2: Inserting an entire row

D-3: Deleting a range

Unit 4 : Using functions

Topic A: 0 Entering functions

A-1: Entering a SUM function

A-2: Using the mouse to enter a function argument

A-3: Inserting a SUM function

Topic B: 0 Using AutoSum

B-1: Using AutoSum

B-2: Using AutoSum to enter several functions at once

Topic C: 0 Using AVERAGE, MIN, and MAX

C-1: Using AVERAGE

C-2: Using MIN

C-3: Using MAX

Unit 5 : Formatting worksheets

Topic A: 0 Formatting text

A-1: Formatting text by using the toolbar

A-2: Formatting a non-contiguous range

A-3: Using the Format Cells dialog box to format text

Topic B: 0 Formatting rows and columns

B-1: Changing column widths and row heights

B-2: Setting alignment

B-3: Applying borders

B-4: Using the border-drawing pencil

Topic C: 0 Number formatting

C-1: Using the Formatting toolbar to format numbers

C-2: Exploring the Number tab of the Format Cells dialog box

C-3: Creating a conditional format

Topic D: 0 Other formatting features

D-1: Copying and clearing formatting

D-2: Using the AutoFormat dialog box to format a range

D-3: Using Find and Replace to change cell formats

Unit 6 : Printing

Topic A: 0 Preparing to print

A-1: Checking spelling on a worksheet

A-2: Previewing a worksheet

Topic B: 0 Page Setup options

B-1: Controlling page orientation

B-2: Controlling margins

B-3: Creating headers and footers

B-4: Displaying gridlines and observing sheet options

Topic C: 0 Printing

C-1: Printing a worksheet

C-2: Working with print areas

Unit 7 : Creating charts

Topic A: 0 Chart basics

A-1: Creating a chart

A-2: Examining the chart elements

A-3: Creating an embedded chart

Topic B: 0 Modifying charts

B-1: Changing chart type

B-2: Formatting chart elements

B-3: Modifying an embedded chart

Topic C: 0 Printing charts

C-1: Printing a chart

Unit 8 : Web features

Topic A: 0 Saving worksheets as Web pages

A-1: Saving a workbook as a Web page

A-2: Using the AutoRepublish feature

Topic B: 0 Hyperlinks

B-1: Inserting and editing hyperlinks

Topic C: 0 Workbooks and e-mail

C-1: Using e-mail to share a workbook

Appendix A : Alternative user input

Topic A: 0 Speech recognition

Topic B: 0 Handwriting recognition

Appendix B : MOUS exam objectives map

Topic A: 0 Core exam objectives

Topic B: 0 Expert exam objectives