Lotus 1-2-3, WYSIWYG

DescriptionThis hands-on workshop demonstrates the practical applications of WYSIWYG graphic technology and how accurate representation of spreadsheet data enhances your work. Experienced Lotus 1-2-3 users will benefit from the new features of this software.

Prerequisite: Lotus 1-2-3, Level 1

Outline:

WYSIWYG Description

WYSIWYG Desktop Publishing

• Bitstream swiss
  
• Bitstream dutch
  
• Other font attributes
  
• Font sizes
  

  Putting WYSIWYG To Work

• Building a worksheet
  
• Applying fonts
  
• Font list
  
• WYSIWYG keystroke
  
• Defining 24 point type
  
• Defining 14 point type
  
• Determining the font definition
  
• Underlining cell contents
  
• Double underline cell contents
  
• Changing row heights
  
• Points definition
  
• Saving a formatted worksheet
  
• .WK1 & .FMT files
  
• Copying worksheets to diskette
  

  Formats & Templates

• Creating a template
  
• Preparing a new worksheet
  
• Importing WYSIWYG formatting
  
• Preparing a new worksheet
  
• Combining worksheets
  
• Widening a column
  
• Defining the title font
  
• Outlining the title
  
• Creating a 3D drop shadow effect
  

  WYSIWYG Graphing

• Graphing vocabulary
  
• Y-axis title
  
• X-axis title
  
• Titles
  
• Legend
  
• X-axis
  
• Y-axis
  
• Y labels
  
• Scale indicator
  
• Margins
  
• Grid lines
  
• Bars
  
• Graphing data
  
• Graphing a group of data
  
• Creating a graph legend
  
• Creating a bar graph
  
• Naming a graph
  

  Worksheets & Graphs Together

• Placing a graph in a worksheet
  
• Moving a graph in the worksheet
  

  Graph Modifications

• Adding a graph title
  
• Adding a graph grid
  

  WYSIWYG Printing Tricks

• Setting a print range
  
• Selecting landscape orientation
  
• Setting left and right margins
  
• Previewing output on the screen
  
• Compressing and expanding the worksheet
  
• Printing the worksheet
  

Return to DGL homepage