Excel 97: Worksheets
Course description
Overview: Students will learn basic worksheet skills and how to work with data in 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:
* Understand 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.
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