Course Outline
Lotus - Basics
Versions 5.0/97/Millennium

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn basic worksheet functions and formulas and how to work with data in spreadsheets.

• Introduction
  • Electronic Spreadsheet
  • Database
  • Charting Package
• Lotus Screen
• Menu Bar
• Menu Bar Commands
• Pull-Down Menu Conventions
• Formula Bar
• Navigator
• @ Function List
• Smart Icon Bar
• Status Bar
• Mode Indicator
• Mouse Shapes
• Facts About the Spreadsheet
• Moving the Cell Pointer
• Correcting Errors
• Undo Feature
• Text as Labels
• Numbers as Labels
• Numbers as Values
• Selecting Cells
• Entering Data
• Creating Formulas

• Circular Reference
• Additional Formulas
• Entering Formulas
• Help Feature
• Basic Functions
• Saving
• Starting a New Spreadsheet
• Opening a File
• Save Vs. Save As
• Switching Between Spreadsheets
• Closing a Spreadsheet
• Changing Column Widths
• Centering Text Over Several Columns
• Formatting Options
• Inserting/Deleting Columns or Rows
• Printing
• Move Feature
• Copy Feature
• Copying Formulas
• Cleaning the Contents of a Cell or Range
• Auto Fill Feature
• Entering Dates
• Entering the Current Date in a Cell
• Entering the Current Time in a Cell
• Exiting From Lotus