Excel 2000:

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