Lotus 1-2-3: The Basics

A CCSO Student Free Computer Course

All comments, suggestions, and inquiries concerning this instructional material, this course, or any other courses that Computing and Communications Services Office offers may be directed to CCSO's User Training and Education Manager:

Lynnell Lacy
1120 Digital Computer Lab (DCL), MC-256
1304 West Springfield Avenue
Urbana, Illinois 61801
(217) 244-1257

• Getting Started
  • What is Lotus 1-2-3 ?
  • Launching Lotus
  • Getting Help
  • Quitting Lotus
• The Lotus Environment
  • General Features
  • SmartIcons
• Working with Workbooks
  • Creating a New Workbook
  • Opening a Workbook
  • Switching between Workbooks
  • Switching between Worksheets
  • Maneuvering within Worksheets
  • Saving a Workbook
  • Closing a Workbook
• Entering and Editing Data
  • Entering Data
  • Editing Data
  • Moving and Copying Data
• Entering Calculations
  • Formulas
  • Functions
  • Function Shortcuts
• Printing a Worksheet

Documentation Conventions

• Bulleted lists contain unordered items (usually multiple options or distinct descriptions).
• Numbered lists indicate a step by step procedure (e.g., 2 must follow 1) or a prioritized list (e.g., 1 is more important or better than 2).
• Commands with keyboard shortcuts are usually executed with modification keys. Modification keys (e.g., control or shift) are held down while the letter following the modifier symbol (or word) is typed. Here is a description of how modification keys are treated:

Step by Step instructions:

Because most commands on the Mac and under Windows can be issued in a number of ways, we'll provide the most basic instructions, those utilizing the mouse. Keyboard shortcuts are usually indicated in the menu and buttons emphasized with special borders can be selected by pressing [return] or [enter].

Examples:

• Sample text from UNIX and DOS will be presented in a non-proportional (monospace) font. Text to indicate commands you should enter will be in monospace bold.
• Sample text for the Macintosh or Windows will be presented in a proportional, sans serif font.
• Any text that should be replaced with appropriate information that you should supply will be in italic (monospace italic for UNIX or DOS, proportional , sans serif italic for Macintosh or Windows). When this is not possible or appropriate, may be used instead.
• HTML conversion note: the conventions presented in the step by step instructions above cannot be reproduced exactly, due to the nature of HTML and the WWW browser.