Further Details
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
Guide price
POA |
