Further Details
At the end of the course the delegate will be able to . . . . .
understand spreadsheet concepts
identify and use all the essential Excel icon commands
open and close a worksheet, use the navigation keys, and the go to command
enter text, values, and formulas into a spreadsheet
understand and use the AutoSum 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 format painter icon to copy formats from one cell to other cells
use cut, copy, paste and delete commands to edit an existing spreadsheet
use the autofill technique to put days, months, and other data quickly into the worksheet
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
create and use range names, using the range finder
use different functions in a spreadsheet using the function wizard 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 worksheet
Delegates should have attended our Windows 95 or Windows NT Introduction level course or be competent in the use of the keyboard and mouse.
Guide price
POA |
