 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Lotus 1-2-3 R97 Introduction
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 95 and familiarity with a standard PC keyboard is required as gained from prior attendance on a "MS Windows 95 Introduction" course. |
Course Audience
Intending, new or recent users of Lotus 1-2-3 R97 for Windows 95 who want to gain a good understanding of the software in a short space of time. |
|
Table of Contents
|
Introduction
|
Starting and Ending a 1-2-3 Session
|
|
Menus, Dialogue Boxes and SmartIcons
|
|
|
|
Basic Skills
|
Moving around the Worksheet
|
|
Inserting and Deleting Rows and Columns
|
|
Saving, Opening and Closing Files
|
|
|
|
Formatting
|
Changing Column Widths and Row Heights
|
|
Using Fonts, Attributes, Lines and Colours
|
|
|
|
Formulae
|
Automatic Versus Manual Calculation
|
|
Using the Function Selector
|
|
Relative and Absolute Addressing
|
|
|
|
Printing
|
Changing the Page Setup and Printer Set-up
|
|
Changing the Printer Set-up
|
|
|
More Functions
|
Preventing Rounding Errors
|
|
Displaying an Integer Value
|
|
|
|
Multiple Spreadsheets
|
Selecting Across Worksheets
|
|
Entering Formulae across Sheets
|
|
|
|
Additional Features
|
Protecting Areas of the Worksheet
|
|
Changing the Worksheet View
|
|
|
|
Charts and Drawing
|
Previewing and Printing Charts
|
|
|
|
Sorting & Databases
|
Sort Order/Performing a Sort
|
|
Using 1-2-3 with External Data
|
|
Creating and Managing a Database
|
|
Record Selection Criteria
|
|
|
|
|
|
