Lotus 1-2-3 Windows 4 or 5: Advanced

Course Code: LOTW45-3 Time: 7 hours

Prerequisites: Lotus 1-2-3 Windows 4 or 5: Intermediate

Overview of Analyses Tools Backsolver What-if Tables Single-Variable What-if Tables What-if Tables with Two Variables 3-Variable or 3-D What-if Tables Version Manager Version Manager Mechanics How Lotus Saves a Version Version Manager Windows Modifying & Updating a Version Comments in Version Manager Displaying Different Versions Working With Multiple Versions The Index Window Navigating in Version Manager Using Scenarios to Put Versions Together Creating a Scenario Selecting Multiple Versions/Scenarios Displaying Versions/Scenarios Creating Version & Scenario Information

Sharing Files LAN Operations Sharing Using Lotus Notes Sharing Files Without a Network Solver How Solver Works Designing the Solver Spreadsheet Macro Basics What is a Macro? Writing a Macro Creating a Macro Work Area Naming a Macro Transcript Window Working in the Transcript Window Recording & Editing the Macro Executing a Macro Quick Review Command Language Keywords Recalling a Macro Macro Library Attaching a Macro to a SmartIcon Creating a Button & Attaching a Macro Creating a List of Macro Names

Return to Course Listing | Home Page