Call our Course Adviser hotline
RIGHT NOW on

COURSE TITLE:

Lotus 1-2-3 Training UK

LEVEL:

Introduction : Intermediate : Advanced

COURSE LENGTH:

1 day

COURSE PRICES:

• On Site Price, at your Home or Office: Click here for Special Rates
• Off Site available for closed groups of 4 or more - Contact Us for a quote or call now on 0870 041 2102 

*All prices quoted exclude VAT

COURSE OVERVIEW:

Lotus 1-2-3 is a business spreadsheet package capable of creating detailed forecasts, budgets and bottom line reports. With proper use, users can maintain vast lists of data - staff information, stock levels etc. It can be used to calculate numerical data, analyse company data and much more.

The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today.

Introduction Level

Starting and Ending a 1-2-3 Session
Menus, Dialogue Boxes and SmartIcons
Parts of the Screen

Basic Skills
Moving around the Worksheet
Files
- Creating new
- Saving
- Opening
- Closing
Selecting Ranges; Entering Data; Editing Cells
Filling a Range, Delete and Undo
Inserting, Deleting Rows and Columns

Formatting
Column Widths
Row Heights
Changing Cell Alignment; Formatting Numbers
Using Fonts, Attributes, Lines and Colours
Cutting Copying and Pasting styles

Set
Formulae
Simple Calculations
Automatic Versus Manual Calculation
Using SmartSum, SmartLabels and SmartFill
Using the Function Selector; Statistical Functions
Relative and Absolute Addressing

Printing
Print Preview; Printing
Changing the Page Setup and Printer Setup
Inserting Page Breaks; Changing the Printer Setup
Hiding Columns; The Print SmartIcon

Intermediate Level

More Functions
Displaying an Integer Value
Conditional Statements
Multiple IF Statements
Date Calculations

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

Additional Features
Spell Check
Find and Replace
Naming Ranges
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
Importing External Data
Creating and Managing a Database
Record Selection Criteria
Finding Records

Advanced Level

3-Dimensional Features
Multiple Page Worksheets
Working with Multiple Worksheets
Multiple Worksheet Navigation
Sheet Names and Tab Colours
Printing; Page Breaks Multiple Files
Working with Multiple Files
Linked Files

Functions
String Manipulation with Text Functions
Concatenation
Logical Functions Operators
Lookup & Calendar Functions
Functions for Dates & Times
Statistical Functions
Information functions - Cell Information

Databases
Database Terms
Adding Records with Lotus Approach
Deleting Database Records
Query Tables
Database Analysis
Connecting to External Databases
Database Statistical Functions
What-if Tables

Problem Solving
Backsolver, Regression
Frequency Distribution

Customising Lotus 1-2-3
Changing the 1-2-3 Setup,
Setting Workbook Properties
Custom Fills
Custom SmartIcons
Creating a New SmartIcon Bar
Adding & Removing Icons on a SmartIcon Bar

BACK TO TOP