XL-ENT
Access 97-1
Access 97-2
Excel 97-1
Excel 97-2
Excel Advanced
Office 97
QuickBooks-1
Quickbooks-2
Quicken
PowerPoint 97-1
PowerPoint 97-2
Windows 95-1
Word 97-1
Word 97-2
Word 97 Advanced

Excel 97: Worksheets (Level 1)

Course specifications

Software version number: 97

Course length: 1 day

Certification

The combined content of the Excel 97: Worksheets and Excel 97: Charting and Organizing Data courses satisfies the requirements for the certified Microsoft Office User for Excel 97 at the Proficient level.

Course description

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

Prerequisites: Windows 95: Introduction, or equivalent knowledge.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to use an electronic spreadsheet to create basic data reports.

Target student: Students enrolling in this course should understand how to use Windows 95.

What's next: Excel 97: Worksheets (Windows 95) is the first course in this series. Excel 97: Charting and Organizing Data (Windows 95), the next course in this series, teaches students how to use the charting and list management capabilities in Excel. Students who want to learn advanced features can take Excel 97: Advanced (Windows 95).

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

Additional information: This course has been designed to help students prepare for the Proficient User certification of the Certified Microsoft Office User Certification with Microsoft Excel 97.