OUTLINE
FOR LOTUS 1-2-3 5.0 LEVEL II
Introduction
Using Lotus 1-2-3 @functions
- @subtotal, @grandtotal
- @avg, @max, @min
- @function selector
Creating tables
- using advanced cell alignment features
Creating charts and maps
- what is a chart?
- plotting a basic chart
- enhancing a basic chart
- plotting noncontinuous data ranges
- creating a pie chart
- using the map feature
Working with a database
- what is a database?
- sorting database records using one or more keys
- querying database records
- specifying multiple criteria in a query operation
- specifying numeric criteria in a query operation
- specifying date criteria in a query operation
Getting help
Controlling the screen display
- splitting the worksheet window
- freezing rows and columns
- reducing and increasing the worksheet display
Final case studies
Duration: 1 day
© Copyright 2000 MicroByte
Computer Center, Inc.
1410 Colonial Life Boulevard
Columbia, SC 29210
(803) 750 -7500
(803) 750 - 0174 (Fax)
| Back to
Training Catalog | Training schedule | Register for Course | Contact Us | |
