Lotus 123
Level 3


Outcomes

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.

Prerequisites

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

Location

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
          Outlining
          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 2017