Microsoft Excel 2003, 2002, 2000 Level 1

1 Day Training Class

Performance-based objectives of this Microsoft Excel 2000 training class:

• Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
• Create a basic worksheet by entering text, values, and formulas.
• Create formulas by using Excels built-in functions.
• Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
• Change the appearance of worksheet data by using a variety of formatting techniques.
• Prepare a document for printing by using the spell checking feature and a variety of printing options.
• Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.
• Save an Excel workbook as a Web page.

Training Course Content:

Lesson 1: Excel basics

• The paper spreadsheet
• The Excel program
• The workbook environment

Lesson 2: Entering data and navigating in a worksheet

• Entering and correcting data
• Saving a file
• Using formulas
• Opening a second file
• Navigation and movement techniques

Lesson 3: Modifying a workbook

• Working with ranges
• Working with functions
• Editing cell contents

Lesson 4: Moving and copying data

• Inserting rows and ranges
• Moving data
• Copying data
• Absolute references
• Using the Fill Series feature

Lesson 5: Formatting a worksheet

• Formatting a worksheet
• Number formats and text alignment
• Copying and pasting formats
• Special and custom formatting

Lesson 6: Printing a worksheet

• Checking spelling
• Using the Print Preview command
• Printing a large worksheet
• Additional print options

Lesson 7: Introduction to the workbook environment

• Using a multiple-sheet workbook
• Creating a chart
• Outlining
• Spreadsheet Solutions

Lesson 8: Creating Excel Web pages

What's Next?  DSOC0262 MS Excel 2003, 2002, 2000 Level 2

Microsoft Excel 2003 training classes in the Nashville and Murfreesboro Tennessee area.