Excel 2003: Basic

Second Edition

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 :  Microsoft Office Specialist exam objectives maps

                               Topic A: 0  Specialist exam objectives

                               Topic B: 0  Expert exam objectives