Lotus 123
Level 2


Participants will learn how to display worksheet data by creating charts; they will also manipulate worksheet ranges by using database operations. Students enrolling in this course should understand the basics of working in a 1-2-3 for Windows worksheet.


Windows (95/98/NT 4) introduction, or equivalent knowledge.
Introduction, 1-2-3 97: Worksheets (Windows 95) or 1-2-3 Millennium Edition: Worksheets (Windows 95), 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

          Introduction to charts
          Creating a basic chart
          Working with multiple charts

          Formatting and enhancing charts

          Enhancing and formatting titles and legends
          Modifying axis information
          Using drawn objects to enhance charts and worksheets

          Using pie charts

          Creating a pie chart
          Enhancing a pie chart

          Advanced charting topics

          Adding and deleting a data series
          Additional enhancements
          Creating charts from 3-D ranges

          Sorting data

          One-column sorts
          Range names
          Multiple-level sorts
          Introduction to data management
          Database terminology and guidelines
          Defining the database table and the find criteria
          Text comparison criteria
          Numeric comparison criteria

          Using query tables

          Working with query tables
          Using multiple criteria
          Managing records in a database table
          Using database functions


          Using maps to chart data
          Integration with Approach

Performance-based objectives
  • Display data graphically by selecting a range and creating a chart.
  • Enhance chart displays by modifying parts of the chart.
  • Display data as parts of a whole by creating and enhancing pie charts.
  • Enhance worksheet and chart data by using drawn objects.
  • Manage data on a worksheet by sorting the rows.
  • Find records in a database table by using a query table.
  • Manage data in a database table by using a query table.

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 2023