Excel 2002: Basic

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