major projects for IT training crown software and compter consultancy

Lotus 1-2-3 Intermediate

Course Aims

This one day course is designed to give an existing Lotus 123 user additional skills and knowledge in the use of many features and functions of the software, to improve efficiency and effectiveness when working with spreadsheets. This entirely “hands on” course will give participants a good understanding of spreadsheet production, multiple worksheets working, creation and use of database and spreadsheet presentation features.

Course Outline

More Functions
Preventing Rounding Errors
Displaying an Integer Value; Conditional Statements
Multiple IF Statements; Date Calculations
The InfoBox

Multiple Spreadsheets
Creating a New Sheet; Perspective View
Selecting Across Worksheets
Entering Formulae across Sheets
Group Mode; Fixing Titles

Additional Features
Spell Check; Find and Replace
Naming Ranges; Protecting Areas of the Worksheet
Changing the Worksheet View; Transpose

Charts and Drawing
Creating a Chart
Manipulating Charts
Using the Drawing Tools
Previewing and Printing Charts

Sorting & Databases
Database Terms and Rules
Sort Order/Performing a Sort
Using 1-2-3 with External Data
Creating and Managing a Database
Record Selection Criteria
Finding Records

Target Audience

Existing users of Lotus 123 who want to get to grips with some of the more advanced features of this package as quickly as possible.

Assumed Knowledge

A basic understanding of PCs, Windows and Lotus 123 is required, gained from experience in the workplace or by attendance on a Lotus 123 Introduction training course.

IT training microsoft office lotus smartsuite

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited