CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APEX201 - Microsoft Excel 2000 Level 1 Spreadsheets

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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

Prerequisites

A general knowledge of Windows

Detailed Class Syllabus

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