Excel 2000 Introduction

1 day

Overview

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

Prerequisites

Windows Introduction, or equivalent knowledge.

Benefits

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

Target student

Studentsshould be comfortable in the Windows environment.

What's next

Excel 2000 Introduction is the first course in this series. Excel 2000 Intermediate, the next course in this series, teaches students how to use charting and formula construction capabilities in Excel. Students who want to learn advanced features can take Excel 2000 Advanced.

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