1-2-3 Millennium Edition 9.5: Worksheets
Course number: LME-L1-076-213
Software version number: 9.5
Course length: 1 day
Hardware/software required to run this course
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.
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.
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