major projects for IT training crown software and compter consultancy

Lotus 1-2-3 Introduction

Course Aims

This intensive course is designed to give an introduction to this powerful integrated product from Lotus. It is an entirely 'hands on' course and those attending will gain a good basic understanding of how to create and manage spreadsheets, graphics and databases.

Course Outline

Introduction
Starting and Ending a 1-2-3 Session
Menus, Dialogue Boxes and SmartIcons
Parts of the Screen; Getting Help

Basic Skills
Moving around the Worksheet
Selecting Ranges; Entering Data; Editing Cells
Delete and Undo; Filling a Range
Inserting and Deleting Rows and Columns
Creating a New File; Saving, Opening and Closing Files

Formatting
Changing Column Widths and Row Heights
Changing Cell Alignment; Formatting Numbers
Using Fonts, Attributes, Lines and Colours
Working with Styles; Cut, Copy and Paste
Set

Formulae
Simple Calculations
Automatic Versus Manual Calculation
Using SmartSum, SmartLabels and SmartFill
Using the Function Selector; Statistical Functions
Relative and Absolute Addressing

Printing
Print Preview; Printing
Changing the Page Setup and Printer Setup
Inserting Page Breaks; Changing the Printer Setup
Hiding Columns; The Print SmartIcon

 


Target Audience

Intending, new or recent users of Lotus 1-2-3 who want to gain a good understanding of the software in a short space of time.

Assumed Knowledge

A basic understanding of PCs, Windows and familiarity with a standard PC keyboard is required, as gained from prior attendance on a "MS Windows Introduction" course or from workplace experience.

 

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited