Lotus 123

Lotus 123

On this 1 day Introduction to Lotus 1-2-3 , students will learn the basics of creating charts from their worksheet data and enhancing those charts. They will also be introduced to database concepts and learn how to work with a range of worksheet data as a database.

Course Content

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 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

Module 0: Working with Lotus 1-2-3
| Starting 1-2-3
Using the Welcome To 1-2-3 Dialog Box
Working with 1-2-3 Windows
Defining Spreadsheet Terms
Moving the Cell Pointer
Using the Infobox


| Module 1: Working with Workbooks
| Creating and Closing a Workbook
Entering Data
Entering Labels and Values Into a Sheet
Saving a New Workbook
Opening and Saving An Existing Workbook
Editing and Deleting Cell Data
Using the Undo Feature


| Module 2: Working with Ranges
| Defining Cell Ranges
Selecting a Range and a Non-adjacent Range
Entering Data Into a Range
Using Smartfill


| Module 3: Creating Simple Formulas
| Using Formulas and Functions
Using the Sum Smarticon
Using Autototal
Using the @function Selector
Entering a Formula


| Module 4: Copying and Moving Data
| Copying and Pasting Data
Filling a Range
Cutting and Pasting Data
Using Drag and Drop
Using Absolute References


| Module 5: Using Page Setup and Printing
| Previewing a Sheet
Zooming the Preview Window
Scrolling Pages in the Preview Window
Viewing Multiple Pages
Changing Page Setup Options and the Page Orientation
Adding a Header and Footer
Formatting Headers and Footers
Printing Grid Lines
Printing the Current Sheet


| Module 6: Formatting Values and Text
| Applying and Clearing Number Formats
Changing the Number of Decimal Places
Changing the Font
Changing the Font Size
Changing the Font Color
Using Automatic Formatting
Adding Font Attributes


| Module 7: Working with Columns and Rows
| Selecting Columns and Rows
Hiding and Unhiding Columns and Rows
Inserting and Deleting Columns and Rows
Changing Column Width and Row Height
Fitting To the Largest Entry
Fitting To the Widest Number


| Module 8: Working with Cell Alignment
| Changing Cell Alignment and Vertical Alignment
Resetting Default Alignment
Centering Text Across Columns
Wrapping Text
Rotating Cell Entries


| Module 9: Formatting Cells
| Adding Cell Borders and Patterns
Copying and Clearing Styles
Using the Style Gallery


| Module 10: Documenting a Sheet
| Displaying Formula Markers
Adding a Note To a Formula
Printing Formulas
Adding and Printing Cell Comments


| Module 11: On-line Help
| Using Help
Ask the Expert
Using Help Topics Dialogue Box
Using Index
Using Microsoft Excel Menu Finder

Designed to get you acquainted with basic statistical concepts and procedures, this course is designed for those who may never have studied statistics but find themselves in a job or role where they need to know some basic statistics, or for those who wish to use statistics to illustrate a campaign or develop an argument. No complex maths are involved, the minimum would be year 10 maths, knowledge of some basic algebra and some knowledge of spreadsheets such as Excel, Lotus 123 or Quatro Pro.

Those who are new to 1-2-3 and who require an introduction to the application, and those who have been working with the package already but have not yet tapped it’s full potential. Some understanding of using a Personal Computer and working in the Windows environment will be expected. The topics covered on our "Introduction to Microsoft Windows" course are an adequate prerequisite for this course.

Course Objectives
The primary objective of this course is to give participants the confidence and enthusiasm to explore the capabilities of this extremely powerful application. The topics covered give an in depth introduction to the spreadsheet, graphic and database facilities of 1-2-3. After attending this two day course participants will be able to design and utilise their own data analysis files within Lotus 1-2-3.

Course Contents

Creating spreadsheets by entering data and formulae.
Understanding the rules of Operator Precedence.
The use of relative and absolute cell addressing.
An introduction to 1-2-3’s @ functions.
How to save, open, close and create new worksheet files.
Moving and Copying .
Use of all Style & View commands.
Cell and File Protection.
Creating File Links.
Use of the Range Fill, Sort, Name and Fill by Example commands.
Short Menus.
The use and customisation of SmartIcons.
Drawing Objects in 1-2-3.
Printing reports from the worksheet.
The creation, use and printing of graphs.
Utilising the Tools, Database, New Query command.
Working with multiple worksheet files.
Setting user preferences.

Pages:- 1 2
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>