Lotus 123
Level 2


Outcomes

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.

Prerequisites

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

Location

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


          Appendix

          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 2017