Excel 2003: Worksheets

 

Course length: 1 day

 

 

Course description

 

Overview: Students will learn basic worksheets skills and how to work with data in worksheets.

 

Excel 2003: Worksheets

 

Performance-based objectives

 

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

 

*     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 Excel’s 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.

 

Excel 2003: Worksheets

 

Course content

 

Lesson 1: Excel basics

The paper spreadsheet

The Excel program

The workbook environment

Task pane navigation

 

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

 

Appendix A: Using Excel as a Web tool

Using Excel as a Web tool

 

Appendix B: New Features in Excel 2003

New Features