Training Courses

Call us on 01324 719698 or Fax 01324 719942

Course Contents

The topics below represent a suggested course content.  However, these can be adapted to meet specific objectives.

• Lotus 123 Basic Overview

• Data Entry and Editing Methods

• Formatting Spreadsheets

How to view, create and apply styles.  Changing number format.  Applying lines and colours, fonts and attributes and alignment.

• Worksheet and File Protection

The delegates will be taught how to seal a file, remove a seal on a file and specify unprotected areas.

• Cell Referencing

Relative, Absolute and Mixed cell referencing.  F4 Formula reference.

• Functions

How to apply @SUM, @ROUND, @COUNT, @MAX & @MIN and @AVG functions.  Entering an @ function.

• Range Names

Creating Range names.  Navigating with Range names and using Range names in formulae/calculations.

• 3D Files

Copying data, Creating 3D Formulae, Naming Worksheet Tabs and Creating New Worksheets.

• SmartIcon Palettes

Changing to and creating to a different SmartIcon palette.

• Graphics

Creating a chart and drawing object.