Microsoft Courses:
Microsoft Excel 2000 Worksheets Training Course

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Students will learn how to use an electronic spreadsheet to create basic data reports.

Students enrolling in this course should understand how to use Windows 98/2000/XP. Excel 2000: Worksheets is designed for the student who has had no previous spreadsheet experience. Students who are not familiar with the Windows environment will probably want to first take the following PTR Content course:

Windows 98/2000: Introduction

Topics covered on the 2 day Microsoft Excel 2000 Worksheets course

Excel Basics

The Paper Spreadsheet

The Excel Program

The Workbook Environment

Entering Data and Navigating in a Worksheet

Entering and Correcting Data

Saving a File

Using Formulas

Opening a Second File

Navigation and Movement Techniques

Modifying a Workbook

Working with Ranges

Working with Functions

Editing Cell Contents

Moving and Copying Data

Inserting Rows and Ranges

Moving Data

Copying Data

Absolute References

Using the Fill Series Feature

Formatting a Worksheet

Formatting a Worksheet

Number Formats and Text Alignment

Copying and Pasting Formats

Special and Custom Formatting

Printing a Worksheet

Checking Spelling

Using the Print Preview Command

Printing a Large Worksheet

Additional Print Options

Introduction to the Workbook Environment

Using a Multiple-sheet Workbook

Creating a Chart

Outlining

Spreadsheet Solutions

Creating Excel Web Pages

Using Excel as a Web Tool

Other Web Options

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk