Lotus 1/2/3 - Level 1

Download PDF

Next Dates:

No dates available yet

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 185

Target audience & Prerequisites:

This Course is designed to cover important features of a Lotus 1-2-3 spreadsheet to new users. Participants must have basic knowledge of the Windows environment, keyboard and mouse operations as well as a basic understanding of mathematics.

Learning objectives:

Upon completion of the course you will be able to create and save a simple spreadsheet, use simple formulas and functions. Format and print your spreadsheets.

Course Outline:

1-2-3 Basic

The paper spreadsheet
Starting 1-2-3
The 1-2-3 window

Entering data and navigating in a worksheet

Entering and correcting data
Using formulas
Opening a second file
Navigation and movement techniques

Modifying a worksheet

Working with ranges
Using @Functions
Editing cell contents
Using 1-2-3 On-Line Help

Inserting rows and moving data

Inserting rows and ranges
Moving data

Copying data

Copying data
Absolute references
Using fill by example

Formatting techniques

Formatting cell contents by using the status bar
Formatting text by using the InfoBox
Formatting numbers by using the InfoBox
Copying styles

Printing a worksheet

Checking spelling
Using Print Preview
Page Setup and Print options

Additional features

Introduction to a three-dimensional workbook
Creating a basic chart
Using SmartMasters>

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List