Lotus 1-2-3, Level 2

This course introduces the intermediate Lotus 1-2-3 user to additional capabilities of the most popular business software: Lotus 1-2-3. Data sorting, finding, and extracting along with automation macros allow controlled access to information. Creation of custom macro menus will be presented to aid users to create fully-functional models that minimize data loss and increase the ease of use for complex worksheets. A must for a well-rounded understanding of Lotus 1-2-3.

Prerequisite: Lotus 1-2-3, Level 1

Outline:

Review & Setup

• Worksheet preparation
  
• Worksheet review
  

  Fundamental Functions

• @IF function format
  
• Creating the @IF function
  
• Copying @IF functions
  
• Nesting @IF functions
  

  Applying Functions

• Preparing the worksheet
  
• Creating a working formula
  
• Standard order of mathematical operations
  
• Worksheet overview
  

  Controlling Recalculation

• Manual recalculation
  
• Testing manual recalculation
  
• Automatic recalculation
  

  Data Protection

• Protecting cells
  
• Selective unprotection
  
• Selective protection
  
• Unprotecting all cells
  

  Graphing Data

• Creating a line graph
  
• Creating a bar graph
  
• Creating a pie chart
  
• Selecting data ranges to be graphed
  
• Viewing a graph
  
• Creating a graph legend
  
• Creating a graph title
  
• Graph group command
  

  Data Tables

• @VLOOKUP function
  
• Using the lookup
  
• How the @VLOOKUP works
  
• Multiple option lookups
  

  Database Sorting

• Data sorting
  
• Multiple key sorting
  

  Database Finding

• Finding a record
  
• Creating the input range
  
• Creating the criteria range
  
• Entering criteria
  
• Finding records
  
• Finding the next record
  

  Database Extracting

• Database extracting
  
• Preparing the ranges
  
• Creating the input range
  
• Creating the criteria range
  
• Creating the output range
  
• Specifying and extracting records
  
• Repeating an extraction
  

  Criteria Examples

• Greater than
  
• Logical and with greater than
  
• Logical and with logical or
  
• Logical and with not equal to
  
• Numerical greater than
  
• Numerical greater than with label
  
• Multiple wildcard
  
• Single wildcard
  

  Advanced Financial Functions

• @PMT, payment
  
• @PV, present value
  
• @FV, future value
  
• @NPV, net present value
  

  Macros

• Saving a file
  
• Writing a macro
  
• Naming a macro
  
• Playing a macro
  
• Macro notes
  
• Creating a menu
  
• Playing a menu
  
• Returning control to the menu
  
• Exiting the menu
  
• Additional menu options
  

Return to DGL homepage