Lotus 1-2-3 Millennium
Edition 9.8
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows XP: Basic or equivalent experience

Unit 1 : Introducing 1-2-3

Topic A: 0 Spreadsheet terminology

A-1: Discussing spreadsheet terminology

Topic B: 0 The 1-2-3 window

B-1: Starting 1-2-3

B-2: Examining the 1-2-3 window

Topic C: 0 Opening and navigating a workbook

C-1: Opening a workbook

C-2: Navigating a workbook

Topic D: 0 Using Help

D-1: Accessing Help

Topic E: 0 Closing a workbook

E-1: Closing a workbook and 1-2-3

Unit 2 : Entering and editing data

Topic A: 0 Creating a workbook

A-1: Creating a new workbook

Topic B: 0 Entering data

B-1: Entering labels and numbers

B-2: Entering formulas

B-3: Entering formulas by using cell references

B-4: Editing data

B-5: Editing a formula

B-6: Adding comments to a cell

Topic C: 0 Saving changes

C-1: Saving a workbook

C-2: Automatically saving a workbook

Unit 3 : Modifying workbooks

Topic A: 0 Moving and copying data

A-1: Moving data by using SmartIcons

A-2: Copying data by using SmartIcons

A-3: Moving data by using the drag-and-drop method

A-4: Copying data by using the drag-and-drop method

Topic B: 0 Formulas

B-1: Moving formulas by using the shortcut menu

B-2: Copying formulas and observing relative references

B-3: Copying a formula by using SmartFill

Topic C: 0 Absolute references

C-1: Observing the limitations of relative references

C-2: Copying formulas by using absolute references

Topic D: 0 Ranges

D-1: Inserting a row and a column

D-2: Inserting a range

D-3: Deleting a range

D-4: Sorting a range

D-5: Automatically filling a range by using SmartFill

Topic E: 0 Handling multiple sheets

E-1: Creating a new sheet

E-2: Moving data between sheets

E-3: Changing properties of sheet tabs

Unit 4 : Using functions

Topic A: 0 Entering functions

A-1: Entering an @SUM function

A-2: Using the @function selector

A-3: Using the Sum SmartIcon

Topic B: 0 Using @AVG, @MIN, and @MAX

B-1: Using the @function selector to enter the @AVG function

B-2: Using the @MIN and @MAX functions

Topic C: 0 SmartLabels

C-1: Using SmartLabels

C-2: Creating a SmartLabel

Unit 5 : Formatting sheets

Topic A: 0 Formatting text

A-1: Using the status bar

A-2: Using the InfoBox

A-3: Formatting a noncontiguous range

Topic B: 0 Formatting rows, columns, and ranges

B-1: Setting column widths and row heights

B-2: Aligning data

B-3: Adding borders

Topic C: 0 Formatting numbers

C-1: Using the status bar to format numbers

C-2: Using the InfoBox to format numbers

Topic D: 0 Other formatting features

D-1: Copying styles

Unit 6 : Charts

Topic A: 0 Creating charts

A-1: Creating a chart

A-2: Examining chart elements

Topic B: 0 Modifying charts

B-1: Adding a data series

B-2: Changing the chart type

B-3: Formatting chart elements

Unit 7 : Printing

Topic A: 0 Print preview

A-1: Previewing a sheet

Topic B: 0 Page setup options

B-1: Controlling orientation

B-2: Setting margins

B-3: Adding headers and footers

B-4: Observing other page setup options

Topic C: 0 Printing sheets

C-1: Printing a sheet

Unit 8 : Advanced features

Topic A: 0 Linking and embedding objects in 1-2-3

A-1: Linking an object

A-2: Embedding an object

Topic B: 0 Web features and hyperlinks

B-1: Converting a range to a Web page

B-2: Inserting and using a hyperlink

B-3: Editing a hyperlink