Lotus 1-2-3, 3D Features

DescriptionThis hands-on workshop is an intensive examination of the three dimensional (3D) worksheet development features of this premier product. It is designed for experienced Lotus 1-2-3 users. Spreadsheet consolidation, linking, and printing will be covered.

Prerequisite: Lotus 1-2-3, Level 2

Outline:

Three Dimensional Worksheets

Positioning Data

• First quarter data
  
• Second quarter data
  
• Third quarter data
  
• Fourth quarter data
  
• Worksheet types
  
• Retrieving a worksheet
  
• Analyzing formulae
  

  2D To 3D Worksheets

• Creating a perspective
  
• Inserting additional sheets
  
• Moving between sheets
  
• Clearing the perspective
  
• Moving 2D data to 3D data
  
• Moving ranges in three dimensions
  
• Enabling the 3D perspective
  
• Enabling group functions
  

  Saving A 3D Worksheet

  Creating A 3D Worksheet

• Inserting a new sheet
  
• Creating consolidation formulae
  
• Creating a 3D formula by pointing
  

  Multiple 2D Worksheets

• A word of caution
  
• Erasing all worksheets
  
• Erasing a single worksheet
  

  Databases In 3D

• Criteria range
  
• Output range
  
• Input range
  
• Querying by last name
  
• Query by age
  
• Clearing the perspective
  

  3D Lookup Tables

• Using lookup tables
  
• Viewing the base range
  
• Viewing the discount range
  
• Data input
  
• @VLOOKUP
  

Return to DGL homepage