Course Outline Lotus 1-2-3 Intermediate

Course Outline
Lotus - Intermediate
Versions 5.0/97/Millennium

P.O. Box 225
5375 Main Street
East Petersburg, PA 17520-0225

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn the skills and concepts necessary to create and use three dimensional spreadsheets, use the Lotus database functions, and create charts.

Introduction

Electronic Spreadsheet

Database

Charting Package

Changing View Modes

Titles

Password Protection

Numbering Items in a Spreadsheet

Copying Formulas

Data Fill to Number a Series

Auto Filling of Ranges with Logical Items

Aligning a Range of Labels

Changing from Horizontal Alignment

Centering Titles Over Columns

Auto Format Feature

Removing Auto Formatting

Range Names

Printing Using Range Names

Range Name Table

Database Functions

Entering Dates

Data Sort

Data Query

Data Find Feature

Data Query Extract

Combing Files

3-D Tabs

Adding

Deleting

Assigning Logical Names

Building Formulas

Protecting Your Worksheet

Manual Recalculation

Auto Save Feature

Absolute Reference

Building Formulas Using Range Names

Charting

Please Call For Class Date

Course Prerequisite
Must have Lotus - Basics or equivalent experience
(4 CPE Credits)