Lotus 1-2-3 Millennium Edition Basic Study Guide

0-619-01106-8 © 2000 Publish date: June 21, 2000 132 pages

Buy Now: $25.99

Course ID: lotus-123-me-basic-sg

Learn how to use the basic functions of Lotus 1-2-3 by choosing the Lotus 1-2-3 Millennium Edition Basic study guide. This convenient, self-directed course will introduce you to the basic tasks and features of this spreadsheet program. Our computer training books range from fundamental skills to advanced certification training. This particular course is an entry level introductory course designed to get you up and running using Lotus 1-2-3.

The Lotus 1-2-3 Millennium Edition Basic courseware contains eight full units of high-quality instruction. Each unit presents the topic in a comprehensive manner taking you step by step through the various processes. It can be read and worked through in about a day or so. If you wish to spread out the lessons, you can easily do one unit per day and finish in about a week. The self-directed format lets you take control of how long to complete the course.

By choosing the Lotus 1-2-3 Millennium Edition Basic courseware, you'll learn spreadsheet terminology, get comfortable with the environment, learn how to create workbooks, enter formulas, manipulate data, work with functions, format your worksheet, work with ranges, create charts, preview and print your workbooks, insert hyperlinks, and transform ranges to web pages.

Course Contents

Unit 1 introduces 1-2-3 basics

• Spreadsheet terminology
• Exploring 1-2-3's window
• Opening and navigating a workbook
• Using Help
• Closing workbooks

Unit 2 covers entering and editing data

• Creating new 1-2-3 workbooks
• How to enter and edit labels and numeric values
• How to enter and edit formulas
• How to enter formulas by typing
• How to use the mouse for entering cell references
• How to edit formulas
• How to save workbooks
• Changing and updating workbooks

Unit 3 goes over modifying worksheets

• Moving data using the Edit menu
• Moving data by using SmartIcons
• Copying data with the Edit menu
• Copying data with SmartIcons
• Moving data with drag-and-drop method
• Copying data with drag-and-drop method
• Moving formulas with shortcut menu
• How to copy formulas and observe relative references
• Copying formulas with SmartFill
• Using absolute references
• Observing limitations of relative references
• How to insert and delete ranges
• How to insert entire rows or columns
• Inserting ranges
• Deleting ranges

Unit 4 covers working with @Functions

• Entering @SUM
• Using the @function selector
• Using Sum SmartIcon
• Using @AVG, @MIN, and @MAX
• Using @function selector for entering @AVG
• Using the @MIN and the @MAX functions
• Working with SmartLabels to total a range
• The SmartLabels Setup dialog box

Unit 5 discusses formatting worksheets

• Working with the Status Bar to format text
• Working with the InfoBox to format text
• Formatting non-contiguous ranges
• How to set column widths and row heights
• How to adjust alignments
• Adding borders
• Other formatting features
• Copying styles

Unit 6 covers printing

• Previewing worksheets
• Page Setup options
• Controlling the page's orientation
• Adjusting margins
• How to add headers and footers
• Other Page Setup options
• Printing a worksheet

Unit 7 discusses charts

• Creating basic charts
• Examining chart elements
• Changing chart types
• Formatting the elements of a chart
• Printing charts

Unit 8 covers Web features

• Converting ranges to Web pages
• Inserting and using hyperlinks