Lotus 123

Advanced 123 v5:

• The Concept of a Database.
• Creating a Database Table
• Sorting Records.
• Finding Records.
• Deleting and Undeleting Records.

• The Lookup Function.
• VLookup.
• HLookup.

• Finding Records Using Multiple Criteria.
• Creating Query Tables.
• Adding and Deleting Functions to the Function Menu.
• Creating and Using What-If Tables.

• What is a Macro.
• Creating a Macro.
• Naming a Macro.
• Saving a Macro.
• Running a Macro.
• Stopping a Macro.
• Editing a Macro.
• Creating a Macro Button
• Creating a SmartIcon

123 v5 Macros:

• What is a Macro?
• The Lotus 123 Recorder
• Recording a Macro
• Relative Record or Absolute Record
• Running a Macro
• Saving and Editing a Macro
• Macro Sheets
• Good Practices
• Good Planning
• Good Habits

• Structured Macros
• Branching
• Looping
• The Macro Toolbar
• Using the IF Statement
• More Examples of the IF Statement
• Using the FOR...NEXT Loop
• Debugging a Macro

• Macro Functions
• Status Bar Messages
• Alert Boxes
• Input Boxes
• References and Select()
• Some Useful Macro Commands and Functions

• Customising the SmartIcons
• Adding and Removing SmartIcons
• Creating a Custom Toolbar
• Custom Commands
• Adding and Removing Custom Commands
• Adding a New Command to a Menu
• Custom Menus
• Add Commands to an Existing Menu
• Add a New Menu to a Menu Bar
• The Automatic Features
• Make a Macro AutoExecutable

Introduction to 123 v9.5:

• What is an Electronic Spreadsheet?
• Spreadsheet Terminology.
• The Lotus 1-2-3 Window & Screen.
• Moving Around the Sheet
• Starting 1-2-3
• Create A Simple Spreadsheet.
• Add Data.
• Exit Lotus 1-2-3
• Summary of the Movement Keys.
• The Lotus Screen

• Setting Column Widths.
• The Formatting Commands.
• Aligning Cell Contents.
• Formatting Numeric Figures.
• Inserting & Deleting Rows & Columns.
• Adding & Centring a Title.
• Editing Data
• Using the AutoFormat Command.
• Exercise.

• The Lotus 123 Menus
• Using SmartIcons
• Formulas
• Entering Formulas
• Copying Cells
• The Sum Function
• Using the Sum SmartIcon
• Create a New Spreadsheet
• Create another Spreadsheet.

• Preview a Worksheet
• Centring & Scaling a Worksheet
• Headers and Footers
• Print a Worksheet
• Techniques in Selecting Cells.
• Selecting a Range
• Selecting Rows and Columns
• Selecting a Collection

Introduction to 123 v97

• What is an Electronic Spreadsheet?
• Spreadsheet Terminology.
• The Lotus 1-2-3 Window & Screen.
• Moving Around the Sheet
• Starting 1-2-3
• Create A Simple Spreadsheet.
• Add Data.
• Exit Lotus 1-2-3
• Summary of the Movement Keys.
• The Lotus Screen

• Setting Column Widths.
• The Formatting Commands.
• Aligning Cell Contents.
• Formatting Numeric Figures.
• Inserting & Deleting Rows & Columns.
• Adding & Centring a Title.
• Editing Data
• Using the AutoFormat Command.
• Exercise.

• The Lotus 123 Menus
• Using SmartIcons
• Formulas
• Entering Formulas
• Copying Cells
• The Sum Function.
• Using the Sum SmartIcon
• Create a New Spreadsheet.
• Create another Spreadsheet.

• Preview a Worksheet
• Centring & Scaling a Worksheet
• Headers and Footers
• Print a Worksheet
• Techniques in Selecting Cells.
• Selecting a Range
• Selecting Rows and Columns
• Selecting a Collection

Intermediate 123 v97:

• What is an Electronic Spreadsheet?
• Relative and Absolute Addresses
• Absolute Addresses.
• The Different Protection Modes.
• Full Protection Using a Password
• Sheet Protection - Read Only
• Protection of Cells or Ranges

• The Chart Facility
• The Chart Assistant
• Adding Chart Titles
• Working with Chart Axes
• Chart Styles
• Printing a Chart

• Worksheet Functions
• Entering @functions
• Function Syntax
• Mathematical Functions
• Date Functions
• Statistical Functions
• Logical Functions
• Use the IF Function
• The @PMT Function
• Range Names
• Using Range Names in Formulas

• The Workbook Concept.
• File Linking.
• Create a Workbook.
• Entering Formulas in a Workbook.
• Linking Sheets in a Workbook.
• Link Files.