Microsoft Excel 2000

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.