Lotus 1-2-3 Millennium Edition

at the end of the course the delegate will be able to . . . . .





understand spreadsheet concepts





identify and use all the essential Lotus 1-2-3 icon commands





open and close a worksheet, use the navigation keys, and the go to command enter text, values, and formulas into a spreadsheet





use the SmartIcons on the toolbars, understand and use Automatic Sum formula tool





format the spreadsheet by changing the column widths and the row heights, change the appearance of typed characters by using bold, italic, fonts





use the fast formatting icon to copy formats from one cell to other cells





use cut, copy, paste and delete commands to edit an existing spreadsheet





use the drag and fill technique to put days, months, and other data quickly into the spreadsheet





sort existing data alphabetically, and numerically, in either ascending or descending order





use and understand absolute cell referencing to create more complex and powerful formulas





use different functions in a spreadsheet using the @function selector to help choose and use the correct function





print the whole worksheet, change the page orientation, put headers and footers onto a printout, insert automatic page numbers and print separate parts of the spreadsheet