SAYERS & ASSOCIATES

Computer Training

 

 

Course Description

LOTUS 1-2-3  (9.8) - LEVEL 3 

Course Length 1 Day - 8 Hour Class Session

Overview Students will learn how to create decision-making formulas, macros, versions, and custom SmartIcon sets.

Prerequisite Introduction to Personal Computers 
Window 2000 Introduction  or Windows XP Introduction
Lotus 1-2-3 (9.8) - Level 1
Lotus 1-2-3 (9.8) - Level 2

Delivery Method Instructor-Led, Group Paced, Classroom-Delivery Learning Model with Structured Hands-On Activities

Benefits Students will learn how to create decision-making formulas, macros, versions, and custom SmartIcon sets

Target Student Students enrolling in this course should understand the basics concepts of working with Lotus 1-2-3- worksheets. They should be familiar with data types (labels and values), copying data, basic formulas and functions, and opening and saving files.

Objectives Create decision-making formulas by using range names and advanced functions.

Display and protect worksheet data by hiding and displaying columns and protecting cells.

Summarize data from several workbooks by creating and modifying formulas that link workbook files

Troubleshoot and analyze data by using the @ ISERR function and the Backsolver.

Analyze information by substituting different sets of data into specified ranges by using versions and version group.

Automate repetitive task by creating and running macros and scripts.

Enhance a worksheetJ ,s appearance by using a designer frames and style templates, and print large worksheets by using print titles and changing the page orientation.

Customize the 1-2-3 work area by modifying an existing SmartIcon set and creating a customized SmartIcon set; and work with the Internet by using built-in internet tools.



Please Contact Us For Class Outlines.

   

                

e-mail.gif (7997 bytes)To Contact Us:

training@sayers-associates.com
Office:    (479) 452-4439
                   (888) 933-3579
    Fax:    (479) 452-4418
       Post Office Box 10783  

             Fort Smith, Arkansas 72917