Objectives: After completing this course, you will know how to: Start Microsoft Excel and identify the main components of the Excel window and an Excel workbook, and use the Help feature. Enter and edit labels, values, and formulas in a worksheet, and find and replace a formula. Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas. Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet, and use the AutoSum feature. Format text, numbers, rows, and columns in a worksheet. Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area. Create, format, modify, and print charts based on worksheet data. Save a worksheet as a Web page, use the AutoRepublish feature, insert and edit hyperlinks in worksheets, and send a workbook via e-mail.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard. |
|
