Lotus 1-2-3 for Windows, Level 2

This course introduces the intermediate Lotus 1-2-3 for Windows user to additional capabilities of this popular business software: Lotus 1-2-3 for Windows. Menu commands to be covered include: worksheet erase, inserting columns, inserting rows, range format. Additional functions such as @SUM, @AVG, @MIN, @MAX, and @COUNT will also be introduced.

Prerequisite: Lotus 1-2-3 for Windows, Level 1

Outline:

Review & Setup

• Worksheet preparation
  
• Worksheet review
  
• Naming ranges
  
• Using named ranges
  
• Creating a range name table
  
• Deleting a range name
  
• Deleting all range names
  
• Range name facts
  

  Fundamental Functions

• @IF function format
  
• Creating the @IF function
  
• Copying @IF functions
  
• Nesting @IF functions
  
• @SUM function
  
• @AVG function
  
• @MIN function
  
• @MAX function
  
• @COUNT function
  
• Range formatting review
  

  Applying Functions

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

  Combining & Comparing Functions

• Preparing the functions
  
• @ROUND function
  
• @INT function
  
• @PMT function
  

  Data Protection

• Protecting cells
  
• Selective unprotection
  
• Selective protection
  
• Unprotecting all cells
  
• Worksheet passwords
  
• Assigning a password
  
• Retrieving a password-protected worksheet
  
• Removing a password
  

  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 chart command
  

Return to DGL homepage