1-2-3 Millennium Edition 9.5: Worksheets

Students will learn how to build, format, and print a basic worksheet

Prerequisites

Windows 98: Introduction or equivalent knowledge

Target Student

Students enrolling in this course should have a basic understanding of personal computers and of Microsoft Windows 98. Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

* Realize the disadvantages of paper spreadsheets and be familiar with the basics of the 1-2-3 environment by examining a paper spreadsheet and starting the 1-2-3 program.
* Create and save a basic worksheet by entering text, values, and formulas; access different areas of a worksheet by using the keyboard and the mouse.
* Modify a worksheet by editing existing data; create formulas by using 1-2-3’s built-in @Functions; and use a number of techniques to access 1-2-3’s On-Line Help system.
* Insert rows into the worksheet and move data by using shortcut menus and the drag-and-drop technique.
* Copy data and quickly fill ranges with data by using shortcut menus and the SmartFill technique.
* Change the appearance of the worksheet by using the status bar and the InfoBox.
* Prepare a document for printing by using the Spell Check feature and a variety of printing options.
* Learn the basics of using three-dimensional workbooks, creating charts, and using SmartMasters.

What's next

1-2-3 Millennium Edition 9.5: Worksheets is the first course in this series. 1-2-3 Millennium Edition 9.5: Charting and Database Functions, the next course in this series, teaches student how to accomplish database and charting tasks. Students who want to learn advanced features can take 1-2-3 Millennium Edition 9.5: Advanced.

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

Benefits

Students will learn how to create a basic worksheet by working with ranges of data, using formulas, and changing the appearance of worksheets.

Course duration

1 Day(s) Course outline

Lesson 1: 1-2-3 Basics

The Paper Spreadsheet
Starting 1-2-3
The 1-2-3 Window

Lesson 2: Entering Data and Navigating in a Worksheet

Entering and Correcting Data
Using Formulas
Opening a Second File
Navigation and Movement Techniques

Lesson 3: Modifying a Worksheet

Working with Ranges
Using @Functions
Editing Cell Contents
Using the 1-2-3 On-line Help

Lesson 4: Inserting Rows and Moving Data

Inserting Rows and Ranges
Moving Data

Lesson 5: Copying Data

Copying Data
Absolute References
Using Fill by Example

Lesson 6: Formatting Techniques

Formatting Cell Contents by Using the Status Bar
Formatting Text by Using the InfoBox
Formatting Numbers by Using the InfoBox
Copying Styles

Lesson 7: Printing a Worksheet

Checking Spelling
Using Print Preview
Page Setup and Print Options

Lesson 8: Additional Features

Introduction to a Three-dimensional Workbook
Creating a Basic Chart
Using SmartMasters

Hardware/software Requirements

You will need 8 megabytes (MB) of Random Access Memory (RAM) if you are using 1-2-3 Millennium Edition (12 MB is recommended if you plan to run 1-2-3 while running other applications). You will need a maximum of 35 MB of hard disk space available for 1-2-3 Millennium Edition 9.5 after Windows 98 is installed. You will also need a typical installation of Windows 98 with 1-2-3 Millennium Edition 9.5.

See your reference manual for hardware considerations that apply to your specific hardware setup. In addition, you will need printers if you want to print the worksheets >created in the course.

Note: This book was written using the Windows 98 platform; however, the manufacturer’s documentation states that 1-2-3 Millennium Edition 9.5 can also run on Windows 95 and Windows NT 4.0.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2012 Wintrac Inc.