| An Introduction to Lotus 123 |
| Choice |
8 evenings over 4 wks (mon & thu) 2 Weekdays : |
6.00pm - 9.00pm 10.00am - 5.00pm |
£120 |
|
Objectives To give trainees an understanding of Lotus 123 for Windows Suitable for: All those who would like to use Lotus 123 for Windows Pre-Requisite PC appreciation and basic keyboard skills would be advantageous |
| Course Outline |
The Concept of Windows
The Spreadsheet Concept
Starting Windows
Accessing 1-2-3 for Windows
Welcome to 1-2-3
1-2-3 Essentials
The 1-2-3 Window, The 1-2-3 Worksheet
Menus & Commands
Quick Menus; SmartIcons
Help System; Worksheet Navigation
Data Entry
Labels, Value, Dates
Labels Versus Values
Editing & Deleting Data; Cell Ranges
Field Management
Saving, Opening, Closing & Deleting a File
Starting a New File
SmartMasters:
Working with SmartMaster Files
Creating a Customised SmartMaster
Editing the Worksheet
Moving & Copying Data
Using Drag & Clear to Delete Data
Column Widths & Row Heights
Inserting & Deleting Columns & Rows
Formula Concepts:
Creating a Formula; Functions
Number Formats
Advanced Formulae:
Copying & Moving Formulae
Rounding Errors
Printing Ranges
Page Setup; Previews; Printing
Presentation
Gallery Templates; Label Alignment
Fonts & Attributes
Lines & Colours; Clearing Styles
Fast Formats; Name Styles
Charts
Chart Elements (Drawn by Row)
Creating an Automatic Chart
Chart Assistant
Creating a Chart Manually
Manipulating & Annotating Charts
Preview & Printing Charts
3-Dimentional Features
Multiple Page Worksheets
GROUP Mode & 3-D printing
Sorting & Databases
What is a Database? Database Terms
Creating & Managing a Database
Finding Records; Query Tables
Additional Features
Spell Checker; Freezing Titles
Window Panes; SmartIcom Palettes
BHI Net Centre
701 High Road
Seven Kings, Ilford
Essex IG3 8RH, UK
Phone : +44 (0)20 8590 2500
Fax: +44 (0)20 8590 2589
email:
training@bhi-netcentre.co.uk
| If this is the only frame you can see Click Here to see our full Training Portfolio |