Excel 2000: Worksheets (Windows)

This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training, Office Suite training, Operating Systems training, Presentations training, Spreadsheets training, Web Browsers training and Word Processing training

Overview

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

Prerequisites

Windows 98: Introduction, or equivalent knowledge

Target Student

Students enrolling in this course should understand how to use Windows 98 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.
Save an Excel workbook as a Web page.

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.

Delivery Method

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

Certification

Excel 2000: Worksheets is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Benefits

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

Course duration

1 Day(s) Course outline

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

Using Excel as a Web tool

Hardware/software Requirements

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.

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved