Excel 2000 Basic Courseware Outline

---

A First Look at Excel 2000

• The Advantages of Using Excel 2000
• hat are Workbooks and Worksheets?
• Creating and Opening Workbooks
• Entering Data
• Further Data Entry Techniques
• AutoCorrect
• AutoComplete
• Using the Pick List
• Navigating in the Worksheet
• Selecting Items Within Excel 2000
• Inserting and Deleting Cells, Rows and Columns
• Saving Workbooks
• Moving Between Worksheets
• Using the Spelling Checker
• Closing an Excel 2000 Workbook
• Exiting Excel 2000

A closer look at the Excel 2000 Screen

• The Standard Toolbar
• The Formatting Toolbar
• Selecting Worksheet Views
• Undo and Repeat
• The Office Assistant

Formatting and Customizing Data

• Formatting Options Within Excel 2000
• Alignment
• Data Indentation and Rotation - Introduced With Excel 2000
• To Center Items in a Cell/Cells
• Using Fonts
• Formatting Numbers
• Decimal Places
• Formatting Columns and Rows
• Deleting Cells, Formats, Objects and Worksheets
• Adding, Editing and Removing Borders
• Using AutoFormat
• Copying Data
• Copying Data Using Drag and Drop
• Copying Columns and Rows

Formulas, Functions and Named Ranges

• Formulas
• Operator Evaluation Order Within Excel 2000
• Functions
• Functions (continued)
• Using the SUM Function
• Other Commonly Used Functions
• Using Paste Function
• Naming Cells and Ranges
• Using Named Ranges With Formulas

Introducing Charts

• Creating a Chart
• Manipulating Charts
• Changing the Chart Type

Printing

• Page Setup
• Margins
• Centering Printed Output
• Headers and Footers
• Sheet Printing Options
• Choosing a Printer and Changing Settings
• Printing a Worksheet
• Printing Multiple Files