Lotus 123
Level 1


Participants will learn how to build, format, and print a basic worksheet. Participants will learn how to create a basic worksheet by working with ranges of data, using formulas, and changing the appearance of worksheets.


Windows (95/98/NT 4) introduction, or equivalent knowledge.

What should you be familiar with?

Session Length

1 Day, 9:00am to 4:30pm


This session is conducted either on site, or at our training rooms.

Topics Covered in this session

          1-2-3 basics
          The paper spreadsheet
          Starting 1-2-3
          The 1-2-3 window

          Entering data and navigating in a worksheet

          Entering and correcting data
          Using formulas
          Opening a second file
          Navigation and movement techniques

          Modifying a worksheet

          Working with ranges
          Using @Functions
          Editing cell contents
          Using 1-2-3 On-Line Help

          Inserting rows and moving data

          Inserting rows and ranges
          Moving data
          Copying data
          Absolute references
          Using fill by example

          Formatting techniques

          Formatting cell contents by using the status bar
          Formatting text by using the InfoBox
          Formatting numbers by using the InfoBox
          Copying styles

          Printing a worksheet

          Checking spelling
          Using Print Preview
          Page Setup and Print options

          Additional features

          Introduction to a three-dimensional workbook
          Creating a basic chart
          Using SmartMasters

Performance-based objectives
  • Realize the disadvantages of paper spreadsheets and be familiar with the basics of the 1-2-3 environment by examining a paper spreadsheet and starting the 1-2-3 program.
  • Create and save a basic worksheet by entering text, values, and formulas; access different areas of a worksheet by using the keyboard and the mouse.
  • Modify a worksheet by editing existing data; create formulas by using 1-2-3's built-in @Functions; use a number of techniques to access 1-2-3's On-Line Help system.
  • Insert rows into the worksheet and move data by using shortcut menus and the SmartFill technique.
  • Copy data and quickly fill ranges with data by using shortcut menus and the SmartFill technique.
  • Change the appearance of the worksheet by using the Status Bar and the InfoBox.
  • Prepare a document for printing by using the Spell Check feature and a variety of printing options.
  • Learn the basics of using three-dimensional workbooks, creating charts, and using SmartMasters.

This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course

About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2024