1-2-3 Millennium Edition 9.5: Worksheets

Course specifications

Course number: LME-L1-076-213

Software version number: 9.5

Course length: 1 day

Hardware/software required to run this course

Course description

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

Prerequisites: Windows 98: Introduction or equivalent knowledge.

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.

Target student: Students enrolling in this course should have a basic understanding of personal computers and of Microsoft Windows 98.

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.

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.

Course content

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