Excel 2003:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows 2000: Basic or equivalent experience

Unit 1 : Getting started

Topic A: 0 Spreadsheet terminology

A-1: Discussing spreadsheet terminology

Topic B: 0 Exploring the Excel window

B-1: Starting Excel

B-2: 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: Using the Help task pane

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 a label

B-3: Finding and replacing

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

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 in a worksheet

A-2: Copying data in a worksheet

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

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

A-5: Copying data by using the Clipboard

Topic B: 0 Moving and copying formulas

B-1: Using shortcut menus to move formulas

B-2: Copying a formula

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 a 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 the AutoSum button

B-2: Using AutoSum to enter several SUM functions

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 to ranges

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

C-3: Creating a conditional format

Topic D: 0 Using Format Painter and AutoFormat

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 in a worksheet

A-2: Using the Research task pane

A-3: Previewing a worksheet

Topic B: 0 Page Setup options

B-1: Setting page orientation

B-2: Setting margins

B-3: Creating custom headers and footers

B-4: Displaying gridlines and observing sheet options

Topic C: 0 Printing worksheets

C-1: Printing a worksheet

C-2: Working with the print area

Unit 7 : Creating charts

Topic A: 0 Chart basics

A-1: Creating a chart

A-2: Examining chart elements

A-3: Creating an embedded chart

Topic B: 0 Modifying charts

B-1: Changing a 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 workbooks as Web pages

A-1: Saving a workbook

A-2: Using the Publish as Web Page dialog box

Topic B: 0 Hyperlinks

B-1: Inserting and editing hyperlinks

Topic C: 0 Sending workbooks via e-mail

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

Appendix A : Instant messaging

Topic A: 0 Instant messages

Appendix B : Alternative user input

Topic A: 0 Speech recognition

Topic B: 0 Handwriting recognition

Appendix C : MOS exam objectives map

Topic A: 0 Core exam objectives

Topic B: 0 Expert exam objectives