Lotus 1-2-3 Windows 5: Introduction

Course Code: LOTW5-1 Time: 7 hours

Prerequisites: Windows: Introduction

The Basics The Spreadsheet Concept The Electronic Spreadsheet Starting 1-2-3 For Windows Windows Screen Elements 1-2-3 Screen Elements Worksheet Cells & Cell Addresses The Mouse and the Keyboard Ranges of Cells Methods for Selecting Ranges Creating a Worksheet Entering Worksheet Data Worksheet Cell Data Types Labels, Label Prefixes, Long Labels Values, Entering Basic Formulas Math Operators, Number/Letter Combinations Creating a New Worksheet Menu Bar File Options - Save, Save As, Close, Open Data Entry Variations Formulas Basic Formula Review @Functions @SUM() Function Circular Reference @AVG, @MAX, @MIN @Function Selector @SUM SmartIcon Order of Operation Documenting Your Work The 1-2-3 Menu System Main Menu, Quick Menus & SmartIcon Bar Command Menu System Menu Commands

Help! Quick Menus The Dynamic Status Bar SmartIcons - Push Button Worksheets Worksheet Mechanics Editing and Deleting Cell Entries Undo - All I Want is Another Chance! Moving and Copying Data Working with Large Worksheets Absolute Addresses Controlling Worksheet Appearance Format Planning Default Appearance Changes Changing Formats for Selected Ranges Number Formats Number Format Options Decimal Places Displayed Number Format Pop-up Lists Entering Dates Dressing Up Your Worksheet Controlling Fonts Lines, Shading and Color Cell Alignment SmartIcon Alignment Column Width & Row Height Adding/Deleting Rows, Columns, & Sheets Printing the Worksheet Print Commands Customizing Printed Reports Headers & Footers Print Titles Page Breaks Spell Checking Ending the 1-2-3 Windows Session

Return to Course Listing | Home Page