Lotus 1-2-3 Windows 5: Intermediate

Lotus 1-2-3 Windows 5: Intermediate

Course Code: LOTW5-2
Time: 7 hours

Prerequisites: Lotus 1-2-3 Windows 5: Introduction

Multiple Worksheets and Files
Group Mode
Duplicating Data Over Multiple Pages
Copy Back
3-D Formulas

3-D Ranges
Multiple Files

External Cell Addresses
Combining Files

Formula Construction
Formula Construction

Absolute References
Names

Naming Ranges

So What are Names Good For?

Deleting Names

Creating Names from Existing Text
Some Very Interesting Functions

Decision making functions

@VLOOKUP()
Quick Sorting
Some More Useful Functions

@PMT()

@ROUND()

@COUNT()

@PURECOUNT()

@WEEKDAY()

Advanced Formatting
Copy and Paste Styles
Fast Format
Named Styles

Creating Styles

Applying Styles

Modifying Styles
Advanced Alignment Options

Centering Across Columns

Hiding/Unhiding Columns/ Sheets
Hiding and Showing Sheets
Protection

Worksheet Protection

Customizing 1-2-3
Controlling Screen Display
Customizing SmartIcon Bars

Adding/Removing Icons

Deleting SmartIcon bars
Drag & Fill
Controlling 1-2-3 Defaults

Default Data Directory

Controlling Zeros

Macros and Graphics
What is This Thing Called Macro?
The Transcript Window

Editing the Transcript

Saving Your Macros

Relative vs. Absolute Macro Recording
Charting Basics
Modifying a Chart

Chart Type

Printing a Chart
Drawing tools

Rectangles, Ellipses, Lines and Arrows

Text Boxes
Moving and Sizing Drawn Objects