Lotus 1-2-3 Advanced
Course Aims
This one-day training course builds on the Intermediate level course to give experienced Lotus
1-2-3 users knowledge of the more advanced features and facilities available within this product, and how to apply them.
Course Outline
3-Dimensional Features
Multiple Page Worksheets
Working with Multiple Worksheets
Multiple Worksheet Navigation
Sheet Names and Tab Colours
Grouping Sheets; 3-D Printing
Printing; Page Breaks
Multiple Files
Working with Multiple Files
Recalculating Linked Files
Functions
Defining and Using 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
Creating and Managing a Database
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
Version Manager
Defining and Using the Version Manager
Modifying a Version
Displaying Version Properties
Creating Version Groups
Creating Reports;
Merging Versions and Groups
SmartMasters
Working with SmartMaster Files
Creating a Customised SmartMaster
Mapping
Setting up a Range of Map Data
Creating a Map; Editing a Map
|
Target Audience
Experienced users of Lotus 1-2-3 who want to gain a deeper understanding of the software in a short space of time.
Assumed Knowledge
A good understanding of PCs, Windows and a fundamental understanding of Lotus 1-2-3 gained from prior attendance on the "Lotus 1-2-3 Intermediate" course.
|
