 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Lotus 1-2-3 R97 Essentials
Course Aims
This intensive course is designed to give an introduction to this powerful integrated spreadsheet product from the Lotus Corporation. It is entirely 'hands on' and readers will gain a good basic understanding of how to create and manage spreadsheets, graphics and databases. |
Assumed Knowledge
A basic understanding of PC's, Windows 95and familiarity with a standard PC keyboard is required as gained from prior attendance on a "Windows 95 Introduction" course. |
Course Audience
Intending, new or recent users of Lotus 1-2-3 for Windows Release 97 who want to gain the essential knowledge and skills for using the software in a short space of time. |
|
Table of Contents
|
Introduction
|
Components of a Spreadsheet
|
|
Changing the Size of the 1-2-3 Window
|
|
Dialogue Boxes and SmartIcons
|
|
|
|
Essential Skills
|
Moving around a Worksheet
|
|
Selecting Areas of the Worksheet
|
|
Entering Data into a 1-2-3 Worksheet
|
|
Deleting a Cell or Range of Cells
|
|
Inserting and Deleting Rows and Columns
|
|
Saving, Opening and Closing Files
|
|
Working with More than One File
|
|
|
|
Formatting
|
Adjusting Column Widths and Row Heights
|
|
Applying Bold, Italic and Underline
|
|
Changing Fonts and Attributes
|
|
The Fonts and Attributes Properties
|
|
Colours, Lines and Patterns
|
|
Styles · Using the Gallery
|
|
Removing Formats but not Cell Contents
|
|
|
Formulae and Functions
|
Mathematical Order of Precedence
|
|
Automatic Versus Manual Calculations
|
|
Using the @Function Selector
|
|
Entering a Function Manually
|
|
Relative and Absolute Addressing
|
|
|
|
Page Setup and Printing
|
Choosing a Different Printer
|
|
|
|
Further Functions
|
Displaying an Integer Value
|
|
Preventing Rounding Errors
|
|
Creating Multiple @IF Statements
|
|
|
|
|
Additional Features
|
|
|
|
|
