Lotus 1-2-3 Millennium 9.8 Basic

This 1-day course is intended for students who are familiar with computers and the Windows operating system, but who know little about spreadsheets. Students will learn the basics of spreadsheets and Lotus 1-2-3. Topics include spreadsheet terminology, navigating and manipulating data in a 1-2-3 workbook, entering functions, formatting workbooks, adding charts and embedded objects to a workbook, and saving data ranges as Web pages.

• Use spreadsheet terminology, start 1-2-3, open and navigate in a workbook, use Help, close workbooks, and exit 1-2-3.
• Create a workbook, enter and edit data and formulas, and save a workbook.
• Move and copy data and formulas; insert, delete, and sort ranges; and use SmartFills.
• Enter functions such as @SUM, @AVG, @MIN, and @MAX, and use SmartLabels.
• Format sheets and copy formatting.
• Create and format a chart by adding a data series, changing chart types and subtypes, and formatting chart elements.
• Preview a sheet and set page orientation and margins, insert headers and footers, and print a sheet.
• Link and embed objects in a sheet; convert a range to a Web page; and insert, use, and edit a hyperlink.

Target audience

Students are expected to have a good working knowledge of using Windows XP and personal computers.

Course content

Introducing 1-2-3 Spreadsheet terminology • The 1-2-3 window • Opening and navigating a workbook • Using Help • Closing a workbook

Entering and editing data Creating a workbook • Entering data • Saving changes

Modifying workbooks Moving and copying data • Formulas • Absolute references • Ranges • Handling multiple sheets

Using functions Entering functions • Using @AVG, @MIN, and @MAX • SmartLabels

Formatting sheets Formatting text • Formatting rows, columns, and ranges • Formatting numbers • Other formatting features

Charts Creating charts • Modifying charts

Printing Print preview • Page setup options • Printing sheets

Advanced features Linking and embedding objects in 1-2-3 • Web features and hyperlinks

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today