This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
Students will learn be introduced to some of the advanced features of Lotus 1-2-3.
Prerequisites
Windows 98: Introduction, 1-2-3 Millennium Edition 9.5: Worksheets
or equivalent knowledge.
Target Student
We designed 1-2-3 Millennium Edition 9.5: Advanced for the student who has a solid understanding of the basic concepts involved in working with 1-2-3 and wants to learn the skills necessary to work with advanced capabilities of Lotus 1-2-3
Performance-Based Objectives
Lesson objectives help students
become comfortable with the course, and also provide a means to
evaluate learning. Upon successful completion of this course,
students will be able to:
- * 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 groups.
- * Automate repetitive
tasks by creating and running macros and scripts.
- * Enhance a
worksheet’s appearance by using designer frames and
style templates, and print large worksheets by using
print titles and changing the page orientation.
What's next
1-2-3 Millennium Edition 9.5: Worksheets is the first course in this series.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Benefits
Students will learn how to use the advanced capabilities of Lotus 1-2-3.
Course duration
1 Day(s)
Course outline
Lesson 1: Advanced Formula
Construction
- Range Names
- The @ROUND Function
- The @IF Function
- The @VLOOKUP Function
Lesson 2: Advanced Worksheet
Management
- Viewing Options
- Hiding Columns of a
Worksheet
- Protecting Worksheet Data
Lesson 3: Using 3-D Workbooks
and Linking Multiple Files
- Using 3-d Workbooks
- Working with Multiple
Files
- Comparing Multiple
Worksheet Files and Linked Files
Lesson 4: Analyzing Information
- The @ISERR Function
- Using the BackSolver
Feature
- Outlining
Lesson 5: Using Versions and
Version Groups
- Creating Versions
- Creating Version Groups
and Version Reports
Lesson 6: Introduction to
Macros and LoutsScript
- Introduction to Macros
- Introduction to
LotusScript
Lesson 7: Enhancing and
Printing Worksheets
- Filling and Transposing
Ranges
- Enhancing Worksheet
Appearance
- Advanced Printing
Techniques
Lesson 8: Customizing the
SmartIcon Bar; Using Internet Tools
- Working with Sets of
SmartIcons
- Customizing a SmartIcon
Set
- Internet Tools
Hardware/software Requirements
- A minimum of 8 megabytes
(MB) of Random Access Memory (RAM). 12 MB is recommended
if you plan to run 1-2-3 Millennium Edition 9.5 while
running other applications. 16 MB of RAM is required for
Windows NT.
- A minimum of 45 MB of
hard-disk space available for 1-2-3 Millennium Edition
9.5 after Windows 98 is installed.
- An IBM PC or compatible
with a 50MHz 486 (or higher) processor.
- A VGA or higher resolution
video card and monitor.
- A mouse or compatible
tracking device.
- A 3.5" 1.44 MB
floppy-disk drive.
- A typical installation of
Windows 98.
- A Custom installation of
1-2-3 Millennium Edition 9.5 including 1-2-3 LotusScript
Help.
See your reference manual for
hardware considerations that apply to your specific hardware
setup.
