Lotus 1-2-3 Windows 5: Transition from a DOS Spreadsheet

Course Code: LOTW5-T Time: 7 hours

Prerequisites: Windows: Introduction and extensive 1-2-3 DOS Experience

Windows The Lotus 1-2-3 Screen The Mouse vs the Keyboard Windows Features Dialog Box Windows Main Menu, Quick Menus, SmartIcon Bars & Pop-up Lists Help! 1-2-3 for DOS Users Closing Windows Spreadsheet Mechanics Creating a Spreadsheet Cell Data Types Editing and Deleting Cell Entries UNDO Drag & Fill Formulas @SUM, @AVG, @MAX, @MIN Circular Reference @Function Selector @SUM SmartIcon Order of Operation Moving and Copying Data Absolute Key Using Locked Titles Documenting Your Spreadsheet Printing, Saving & Opening Files Customizing Printed Reports Headers & Footers Compressed Printing Default Settings & Named Settings Spellcheck New, Open, Save, Save As, and Close Ending the 1-2-3 Windows Session

Controlling Spreadsheet Appearance Format Planning Spreadsheet Appearance Changes Changing Formats for Ranges Entering Dates Dressing Up Your Spreadsheet Fonts, Lines, Shading, Color, Cell Alignment Named Style and Style Gallery Copying Attributes & Styles Page Breaks Column Width & Row Height Adding/Deleting Rows, Columns/Sheets Multiple Pages & Files Multiple Sheets Page Tabs Inserting and Deleting Sheets Splitting a Window Perspective and Group Mode 3D Range Selections Multiple Page Formulas Multiple Files Linking Files With Formulas More From 1-2-3 Customizing the SmartIcon Bar Filling a Range With Data Sorting Data Graph Command Appendix New in Lotus 1-2-3 Windows 5 Keyboard Movement & Edit Keys 1-2-3 File Extensions & Translation Rules Parse

Return to Course Listing | Home Page