Beginning

Intermediate

 Advanced

Module 1: Lotus 1-2-3 Basics. Navigate the Worksheet, Explore the Menus, Select Multiple Cells, Manipulate SmartIcons, Create a Spreadsheet, Save a Spreadsheet, Edit the Spreadsheet, Get Help

Module 2: Basic Formulas. Write a Formula, Use the @Function Selector, Use the Sum SmartIcon, Use the Copy Commands, Create Absolute References

Module 3: Formatting and Printing. Check Spelling, Use the Style Gallery, Set Up a Printout, Create Headers and Footers, Scale the Print Area, Print the Document

Module 4: Charts. Create a Chart, Change Chart Types, Modify a Chart, Create a Pie Chart, Create a Map

Module 5: Database Basics. Sort a Database, Perform Multiple-Key Sorts, Find Records, Delete Records

Module 6: Database Management. Define Queries, Modify a Query Table, Use Database Functions, Create a Crosstab Report, Aggregate a Query Table, Connect to an External Table

Module 7: Link & Protect Worksheets. Formula-Link Worksheets, Command-Link Worksheets, Use Named Ranges, Link Worksheet Files, Combine Files, Assign Passwords

Module 8: Macros. Record a Macro, Debug a Macro, Edit a Macro, Create a Macro Button

Module 9: Using IF Logic. Use Backsolver, Determine Frequency Distribution, Use the Version Manager, Use the @IF Function, Nest @IF Functions, Combine Logical Functions, Use a SmartMaster Template

Module 10: Advanced Data Management. Use @HLOOKUP, Use @VLOOKUP, Create a One-Variable Table, Create a Two-Variable Table, Create a Three-Variable Table

Module 11: Advanced Macros. Write an Interactive Macro, Use the {IF} Command, Control the Macro Flow, Control Data Entry

Module 12: Customizing Lotus 1-2-3. Create Custom Menus, Create a Custom SmartIcon Set, Auto-Execute a Macro, Create a Dialog Box