1-2-3 Millennium Edition: Advanced

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 how to create decision-making formulas, protect worksheet data, analyze information by using versions and version groups, automate tasks by creating macros and scripts, and create custom SmartIcon sets.

Prerequisites

Windows 95: Introduction and 1-2-3 Millennium Edition: Worksheets (Windows 95), or equivalent knowledge.

Target Student

Students enrolling in this course should understand the basic concepts of working with 1-2-3 worksheets. For example, they should be familiar with data types (labels and values), copying data, basic formulas and functions, and opening and saving files. 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
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

What's next

1-2-3 Millennium Edition: Advanced (Windows 95) is the last 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 create decision-making formulas, macros, versions, and custom SmartIcon sets.

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 LotusScript

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

You will need 8 megabytes (MB) of Random Access Memory (RAM) if you are using 1-2-3 Millennium Edition. See your reference manual for hardware considerations that apply to your specific hardware setup.

In addition, you will need printers if you want to print the worksheets >created in the course.

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved