 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Lotus 1-2-3 R97 Intermediate
Course Aims
This intensive course is designed to give existing Lotus 1-2-3 R97 users additional skills and knowledge in the use of the many features and functions of the software, to improve efficiency and effectiveness when working with spreadsheets. This entirely 'hands on' course will give readers a good understanding of spreadsheet production, multiple worksheet working, creation & use of databases and spreadsheet presentation features |
Assumed Knowledge
A basic understanding of PC's, Windows 95 and Lotus 1-2-3 R97 is required, gained from previous experience or by attendance on a "Lotus 1-2-3 R97 for Windows 95 Essentials" course. |
Course Audience
Existing users of Lotus R97 for Windows 95 who want to get grips with some of the more advanced features of this package as quickly as possible. |
|
Table of Contents
|
Further Functions
|
Displaying an Integer Value
|
|
Preventing Rounding Errors
|
|
Creating Multiple @IF Statements
|
|
|
|
Working with Multiple Spreadsheets
|
Selecting Cells across Worksheets
|
|
Entering a Formula across Worksheets
|
|
Copying and Moving between Worksheets
|
|
|
|
Multiple Files
|
Working with Multiple Files
|
|
Recalculating Linked Files
|
|
Protecting Areas of the Worksheet
|
|
Changing the Worksheet View
|
|
|
|
Charts and Drawing
|
Creating and Selecting Charts
|
|
Moving, Sizing and Deleting Charts
|
|
Deleting or Moving Chart Elements
|
|
Previewing and Printing Charts
|
|
|
Databases
|
Finding Data in a Database
|
|
Deleting Database Records
|
|
|
|
SmartMasters
|
Working with SmartMaster Files
|
|
Creating a Customised SmartMaster
|
|
|
|
|
What-if Tables
|
|
|
|
Problem Solving
|
|
|
Mapping
|
Setting up a Range of Map Data
|
|
|
|
|
|
