CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APLOT93 - Lotus 123 Release 9.5 Charting and Database Functions

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Students will learn how to display worksheet data by creating charts and how to manipulate worksheet ranges using database operations.

Prerequisites

Course APLOT92: Lotus 123 Release 9.5 Advanced or equivalent knowledge

Detailed Class Syllabus

Lesson 1: Introduction to Charts

Creating a Basic Chart

Working with Multiple Charts

Lesson 2: Formatting and Enhancing Charts

Enhancing and Formatting Titles and Legends

Modifying Axis Information

Using Drawn Objects to Enhance Charts and Worksheets

Lesson 3: Using Pie Charts

Creating a Pie Chart

Enhancing a Pie Chart

Lesson 4: Advanced Charting Topics

Adding and Deleting a Data Series

Additional Enhancements

Creating Charts from 3-D Ranges

Lesson 5: Sorting Data

One-column Sorts

Range Names

Multiple-level Sorts

Lesson 6: Introduction to Data Management

Database Terminology and Guidelines

Defining the Database Table and the Find Criteria

Wildcards

Numeric Comparison Criteria

Lesson 7: Using Query Tables

Working with Query Tables

Using Multiple Criteria

Managing Records in a Database Table

Using Database Functions