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.
|