Lotus 123
Level 3


Participants will learn how to create decision-making formulas, macros, versions, and custom SmartIcon sets. 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.


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

What should you be familiar with?

Session Length

1 Day, 9:00am to 4:30pm


This session is conducted either on site, or at our training rooms.

Topics Covered in this session

          Advanced formula construction
          Range names
          The @ROUND function
          The @IF function
          The @VLOOKUP function

          Advanced worksheet management

          Viewing options
          Hiding columns of a worksheet
          Protecting worksheet data

          Using 3-D workbooks and linking multiple files

          Using 3-D workbooks
          Working with multiple files
          Comparing multiple worksheet files and linked files

          Analyzing information

          The @ISERR function
          Using the Backsolver feature
          Creating versions
          Creating version groups and version reports

          Introduction to macros and LotusScript

          Introduction to macros
          Introduction to LotusScript

          Enhancing and printing worksheets

          Filling and transposing ranges
          Enhancing worksheet appearance
          Advanced printing techniques

          Customizing the SmartIcon bar; using Internet tools

          Working with sets of SmartIcons
          Customizing a SmartIcon set
          Internet tools

Performance-based 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 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

This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course

About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2023