Excel 2000: Worksheets

Course specifications

Course number: 074 200

Software version number: 2000

Course length: 1 day

Hardware/software required to run this course

You will need 32 megabytes (MB) of Random Access Memory (RAM) in order to run Excel. You will need a minimum of 500 MB of hard-disk space available for Office 2000 after Windows 98 is installed. A Pentium 90 or higher processor is needed. A typical installation of Windows 98 and a full-suite installation of Microsoft Office 2000 is needed. In addition, you will need printers if you want to print the worksheets created in the course. At a minimum, you will need to install a printer driver. This book has been developed using the Windows 98 platform; however, this course has been tested and runs on Windows 95, Windows 98, and Windows NT 4.0.

Course description

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

Prerequisites: Windows 98: 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 98.

What's next: Excel 2000: Worksheets is the first course in this series. Excel 2000: Charting and Organizing Data, 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 2000: Advanced.

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:

Course content

Lesson 1: Excel basics

Lesson 2: Entering data and navigating in a worksheet

Lesson 3: Modifying a workbook

Lesson 4: Moving and copying data

Lesson 5: Formatting a worksheet

Lesson 6: Printing a worksheet

Lesson 7: Introduction to the workbook environment

Lesson 8: Creating Excel Web pages

  • Using Excel as a Web tool