Lotus 1-2-3 Millennium Edition 9.8 Basic Study Guide

0-619-28571-0 © 2006 Publish date: February 1, 2005 166 pages

Buy Now: $25.99

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

CBT Planet brings you the perfect choice for learning basic Lotus 1-2-3 skills, the Lotus 1-2-3 Millennium Edition 9.8 Basic study guide. This self-study course is intended for those of you who are comfortable with computers and Windows but would like to expand your knowledge into spreadsheets. You will learn spreadsheets basics and fundamental Lotus 1-2-3 skills.

The Lotus 1-2-3 Millennium Edition 9.8 Basic courseware includes spreadsheet terminology, navigating and manipulating data in workbooks, how to enter functions, how to format workbooks, how to add charts and embedded objects, and how to save data ranges as Web pages.

Our computer training books have been chosen for their quality content and convenient portability. You can learn how to use Lotus 1-2-3 by studying using this book either on its own or by supplementing you classroom learning.

The Lotus 1-2-3 Millennium Edition 9.8 Basic courseware consists of eight full units covering a wide variety of basic tasks designed to get you up to speed with using spreadsheets. By the end of the course, you will be able to begin using Lotus 1-2-3 for creating simple spreadsheets.

Hands-on activities and section reviews let you create spreadsheets by following specific steps illustrated in the courseware. You'll get practical knowledge that you can put to use right away.

Course Objectives

By taking this course, you will learn spreadsheet terminology, how to start 1-2-3, how to open and navigate a workbook, how to use Help, how to close your workbooks, and how to exit 1-2-3.

In addition, you will create your own workbooks, enter data and formulas, edit your data, and save your workbook. You will also learn about moving and copying data and formulas, inserting, deleting, and sorting ranges, and how to use SmartFills.

You will learn how to use SmartLabels and how to use functions including @SUM, @AVG, @MIN, and @MAX.

Formatting sheets and charts are covered along with how to add a data series, change chart types and subtypes, and format various chart elements.

You will learn how to set page margins and orientations, insert both headers and footers, preview your sheet, and print your sheet.

You will move on to learn about linking and embedding objects in a worksheet, converting ranges into web pages, and how to work with hyperlinks.

Course Contents

Unit 1 introduces Lotus 1-2-3

• Spreadsheet terminology
• The 1-2-3 window
• How to open and navigate workbooks
• Using Help
• Closing workbooks

Unit 2 covers entering and editing data

• How to create workbooks
• How to enter data
• How to save changes

Unit 3 goes over modifying workbooks

• Moving data and copying data
• Formulas
• Absolute references
• Ranges
• How to handle multiple sheets

Unit 4 covers functions

• Entering functions
• Working with @AVG, @MIN, and @MAX
• SmartLabels

Unit 5 discusses how to format sheets

• Formatting text
• Formatting rows, columns, and ranges
• Formatting numbers
• Other formatting features

Unit 6 covers charts

• How to create charts
• How to modify charts

Unit 7 discusses printing

• Using print preview
• Page setup options
• How to print worksheets

Unit 8 covers advanced features

• How to link and embed objects
• Web features and hyperlinks