CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APLOT91 - Lotus 123 Release 9.5 Worksheets

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 how to create a basic worksheet by working with ranges of data, using formulas, and changing the appearance of worksheets.

Prerequisites

A general knowledge of Windows

Detailed Class Syllabus

Lesson 1: 1-2-3 Basics

The Paper Spreadsheet

Starting 1-2-3

The 1-2-3 Window

Lesson 2: Entering Data and Navigating in a Worksheet

Entering and Correcting Data

Using Formulas

Opening a Second File

Navigation and Movement Techniques

Lesson 3: Modifying a Worksheet

Working with Ranges

Using @ Functions

Editing Cell Contents

Lesson 4: Inserting Rows and Moving Data

Inserting Rows and Ranges

Moving Data

Lesson 5: Copying Data

Copying Data

Absolute References

Using Fill by Example

Lesson 6: Formatting Techniques

Formatting Cell Contents by Using the Status Bar

Formatting Text by Using the InfoBox

Formatting Numbers by Using the InfoBox

Copying Styles

Lesson 7: Printing a Worksheet

Checking Spelling

Using Print Preview

Page Setup and Print Options

Lesson 8: Additional Features

Introduction to a Three-dimensional Workbook

Creating a Basic Chart

Using SmartMasters