Excel 2000:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows 95: Basic, Windows 98: 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 Opening and navigating a workbook

C-1: Opening a workbook

C-2: Navigating a worksheet

Topic D: 0 Closing a workbook

D-1: Closing a workbook and exiting Excel

Unit 2 : Entering and editing data

Topic A: 0 Creating a new Excel workbook

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

Topic D: 0 Saving and updating a workbook

D-1: Saving a workbook

D-2: Changing and updating a workbook

Unit 3 : Modifying a worksheet

Topic A: 0 Moving a copying data

A-1: Moving data using the Edit menu

A-2: Moving data using the Standard toolbar

A-3: Copying data using the Edit menu

A-4: Copying data using the Standard toolbar

A-5: Moving data using the drag-and-drop method

A-6: Copying data using the drag-and-drop method

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: Pasting 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, MAX, and COUNT

C-1: Using AVERAGE

C-2: Using MIN

C-3: Using MAX

C-4: Discussing COUNT

Unit 5 : Formatting worksheets

Topic A: 0 Formatting text

A-1: Formatting text 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

B-2: Setting alignment

B-3: Applying borders

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

Unit 6 : Printing

Topic A: 0 Preparing to print

A-1: 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 opions

Topic C: 0 Printing

C-1: Printing a worksheet

C-2: Working with print areas

Unit 7 : Creating charts

Topic A: 0 Creating a chart

A-1: Creating a chart

A-2: Examining 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 charts

Unit 8 : Web features

Topic A: 0 Saving a worksheet as a Web page

A-1: Saving a worksheet as a Web page

Topic B: 0 Adding hyperlinks

B-1: Inserting and using hyperlinks

Topic C: 0 Sending a workbook via email

C-1: Using email to share a workbook