1-2-3 Millennium Edition 9.5: Advanced

Course description

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.

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.

Course content

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