Lotus 123 5.0-Part 1 Lotus 123 5.0-Part 2
Lotus 123 5.0-Part 1
Lotus 123 5.0-Part 2
Lotus 123 5.0 – Part 1
6 Hours / $225
Lesson 1: Introduction to Lotus 1-2-3 for Windows
A) Starting Lotus 1-2-3 for Windows
B) Exiting the Lotus 1-2-3 program
C) Screen elements
Lesson 2: Navigating
A) The current cell and the cell pointer
B) Navigating by keyboard: The Pointer-Movement keys
C) Navigating with the mouse: Pointing, clicking and scrolling
D) The Scroll Lock feature
E) The GO TO feature (F5)
Lesson 3: Data Types and Entry
A) Planning the worksheet project
B) Specifics of planning the regional sales worksheet
C) Data entry basics
D) Entering labels and prefixes
E) Entering values
F) Text and numbers entered into the same cell
G) Formulas
H) @functions
I) Common @functions
J) Removing data
K) Range, fill by example
L) Drag-and-Fill
M) Getting out of trouble
N) Regional sales exercise
Lesson 4: File Management
A) To save a file for the first time
B) Displaying file information
C) Renaming the worksheet
D) Saving an existing worksheet
E) Closing a worksheet
F) Opening an existing worksheet file
G) Opening multiple files at once
H) Creating a new worksheet
I) SmartMaster templates
Lesson 5: Range Operations
A) Selecting a cell
B) Selecting a range
C) Selecting a collection
D) Selecting a column or row
E) Moving a range
F) Copying a range
G) Copy to adjacent cells
Lesson 6: Number Formats
A) Formats defined
B) Range formatting
C) Clearing number formats
Lesson 7: Attribute Enhancements
A) Changing fonts and attributes
B) Removing attributes
C) Colors and patterns
D) Borders and frames
E) Removing borders and frames
F) Alignment
G) Copying styles
Lesson 8: Projection Worksheet Exercise
A) Creating a projection
Lesson 9: Modifying the Worksheet Structure
A) Changing the width of a column
B) Changing the width of a range of columns
C) Inserting rows or columns
D) Deleting rows or columns
E) Inserting a range
F) Deleting a range
G) Hiding columns
H) To display hidden columns
Lesson 10: Printing
A) Printing the worksheet
B) Print preview
C) Page setup
D) Using page breaks
Lesson 11: Techniques for Managing a Large Worksheet
A) Freezing titles
B) Removing titles
C) Splitting the screen
D) Moving between split screens
E) Removing the split screen
Lotus 123 5.0 – Part 2
6 Hours / $255
Lesson 1: Multiple Worksheets
A) Worksheets tabs
B) Naming worksheets
C) Inserting worksheets
D) Deleting worksheets
E) The current worksheet and moving between worksheets
F) Naming worksheets automatically
G) Displaying / hiding worksheet tabs
H) Viewing more than one worksheet
I) Group mode
J) 3D range selection
K) Creating formulas across worksheets
L) Worksheet tab colors
Lesson 2: Range Names
A) Navigator
B) Creating range names
C) Using text entries as range names
D) Using GO TO with range names
E) The NAME key
F) Applying range names
G) Deleting a range name
Lesson 3: Dates and Times
A) Date numbers
B) Inserting date/time
C) Date & time calculations
D) Referencing the day, month or year
Lesson 4: Find and Replace
Lesson 5: Relative vs. Absolute Cell References
A) Relative references
B) Absolute references
C) The absolute key
Lesson 6: Logical Formulas
A) Logical operators
Lesson 7: The IF @Function
A) The AND logical operator
B) The OR logical operator
C) The NOT logical operator
Lesson 8: The PMT @Function
A) The twelfth root
Lesson 9: The FV @Function
Lesson 10: What-If Tables
A) 1-Variable table
B) 2-Variable table
C) 3-Variable table
Lesson 11: Sorting
Lesson 12: Maps
Lesson 13: Lookup Tables
A) VLOOKUP and HLOOKUP @function
B) Text string lookup tables
C) Numerical lookup tables
Lesson 14: Linking Tables
A) Updating links
B) DDE/OLE links
Lesson 15: Charts
A) Embedding charts
B) Changing chart types
C) Chart titles and footnotes
D) Modifying legends
E) Chart axis
F) Saving and finding charts