Excel 2000: Basic

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