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