1-2-3 Millennium Edition 9.5: Worksheets

This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training, Office Suite training, Operating Systems training, Presentations training, Spreadsheets training, Web Browsers training and Word Processing training

Overview

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.

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved