Lotus 1-2-3, Level 1

This course introduces the new Lotus 1-2-3 user to the benefits and capabilities of the most popular business software: Lotus 1-2-3. Menu commands to be covered include: file save, file retrieve, copy, range erase, and print, as well as worksheet erase, inserting columns, inserting rows, range format. Additional functions such as @SUM, @AVG, @MIN, @MAX, and @COUNT will also be introduced. Spreadsheet fundamentals and financial management will also be discussed.

Prerequisite: Hard Disk Management

Outline:

Getting Started with Lotus 1-2-3

• Viewing a worksheet
  
• Lotus 1-2-3 capabilities
  

  Worksheet Movement

• Ledger on the screen
  
• Movement keys
  

  Working With Lotus 1-2-3

• Creating a budget
  
• Screen details
  
• Control panel
  
• Cell address
  
• Mode indicator
  

  Data Types

• Label
  
• Label alignment
  
• Value
  
• Formula
  
• Typing a formula
  
• Pointing a formula
  
• Editing cell contents
  

  Using On-Line Help

  Command Menu

• Erasing a range
  
• Saving a worksheet
  
• Erasing a worksheet
  
• Retrieving a worksheet
  
• Adjusting column widths
  
• Range format
  
• Exiting 1-2-3
  

  Copying Cell Data

• Copy command
  
• Placing the cell pointer
  
• Start the command
  
• Highlight the cells to be copied
  
• Select the destination
  
• Repeating the process
  
• Relative cell reference
  
• Absolute cell reference
  

  Rows & Columns

• Inserting rows
  
• Deleting rows
  
• Inserting columns
  
• Deleting columns
  

  Printing

• Printing a range
  
• Returning to the ready mode
  

  Named Ranges

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

  Data Protection

• Worksheet passwords
  
• Assigning a password
  
• Retrieving a password-protected worksheet
  
• Removing a password
  

  Fundamental Functions

• @SUM function
  
• @AVG function
  
• @MIN function
  
• @MAX function
  
• @COUNT function
  

  Combining & Comparing Functions

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

Return to DGL homepage