Lotus 123 Level 1

Outcomes

Participants will learn how to build, format, and print a basic worksheet. Participants will learn how to create a basic worksheet by working with ranges of data, using formulas, and changing the appearance of worksheets.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

1-2-3 basics The paper spreadsheet Starting 1-2-3 The 1-2-3 window Entering data and navigating in a worksheet Entering and correcting data Using formulas Opening a second file Navigation and movement techniques Modifying a worksheet Working with ranges Using @Functions Editing cell contents Using 1-2-3 On-Line Help Inserting rows and moving data Inserting rows and ranges Moving data

Copying data Absolute references Using fill by example Formatting techniques Formatting cell contents by using the status bar Formatting text by using the InfoBox Formatting numbers by using the InfoBox Copying styles Printing a worksheet Checking spelling Using Print Preview Page Setup and Print options Additional features Introduction to a three-dimensional workbook Creating a basic chart Using SmartMasters

Performance-based objectives

• 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; 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 SmartFill 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.