Click Here to Print Page

123- The Spreadsheet That's Revolutionizing the World... Again

Introduction Lotus 1-2-3

The spreadsheet that started it all offers powerful ways to work with numbers.  This is the introductory level for first time users, and for those of you that are self taught.  After your tour of the Lotus product and window, you will learn how to build useful formulae, understand the mathematical order of operations, use built-in Lotus functions, explore formatting, and then page setup for printing.   Learn how to copy formulae and realize why you must always check your work!  We will show you how to "lock" address references within formulae for proper copying results and how to make your work presentable for easy understanding of the data.

Using 1-2-3 for Windows
A. 1-2-3 Window Components and Types of Windows
B. Choosing Commands and selecting Data
C. SmartIcons
D. Opening Files
E. Managing Windows
F. Using the Help Feature

Using Worksheets
A. Navigating around the Worksheet using the mouse and Keyboard
B. Selecting and Naming Ranges
C. Using GROUP Mode for a File
D. Enter, Edit, Copy, Move, and Remove Data
E. Inserting Columns, Rows, and Worksheets
F. Changing Column Width and Row Heights
G. Saving Worksheet Files

Changing Appearance of Data
A. Formatting Numbers
B. Changing Fonts and Color
C. Aligning Labels, Removing Grid Lines, Adding Borders

Protecting Data
A. Preventing Changes to Data, Removing Protection
B. Limiting Access to Data, Hiding Data
C. Printing and Previewing

Calculating with Formulas and Functions
A. Types of Formulas - Entering, Moving, Recalculating Formulas
B. Working with @Functions
C. Argument Types

Cost: $225 per person, 10% discount for 3 or more bookings (plus GST)
Duration: ONE FULL DAY - 9:00 to 4:30 OR TWO Evenings
Prerequisite: Introduction to Microsoft Windows
Includes: Student manual, certificate, and 2 months of Hotline support

Call ComputerEase @ 972-3533 to register...


horizontal rule


Copyright ComputerEase 1999. Page last updated August 23, 2001.