Lotus 123 - Interm

Enquire About This Course

This 1 day course progresses from the one day introduction course to study multiple worksheets, charts and drawings, databases, statistical functions and other useful features of Lotus 123

Prerequisites

Users should have completed an Introduction to Lotus 123 course or are familiar with basic formulas and entering/ editing data

Course Objectives

Linking worksheets and workbooks,   Setting up, analysing and reporting on lists, Creating charts, If Statements, lookup Wizards ,  Other useful features of Lotus 123

Course Content

Splitting Screens

Freezing Panes

Hide/Unhide

• Hide Columns & Rows
• Hide Worksheets

AutoFill

• Stepping through Range Fill
• Creating Custom Lists

Relative v. Absolute

If Function

• Other Logical Operators

Lookup Tables

Multiple Worksheets

• Navigating
• Renaming sheets
• Manipulating sheets
• ing§ Formatting
• Calculating

File & Sheet Linking

Graphical Images

• ing Pictures or Clipart
• The Drawing Toolbar

Charts / Graphs

• Chart Terms
• Using the Chart Wizard
• Formatting the Charts
• Printing Charts

Databases

• Data Form
• Sorting
• Filtering
• Advanced Filter
• Calculating

Click here to download:

Lotus 123 - Intermediate

Enquire About This Course