Course Objectives: Intermediate Microsoft Excel 2003

Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.

• Find and replace a specific entry in a worksheet.
• Create and apply a style.
• Enter an absolute cell reference into a formula.
• Use the PMT and FV functions.*
• Use the IF function.
• Use the DATE and NOW functions.
• Plot a basic chart.
• Modify and enhance a basic chart.
• Add new data to an existing chart.
• Filter a list.
• Specify a criteria range in a filter operation.
• Set up related worksheets within a workbook.
• Enter a formula to link related worksheets in a workbook.
• Format multiple worksheets in one operation.
• Split the Workbook window into panes.*
• Hide the rows and columns of a worksheet.
• Change the zoom level for a worksheet.
• Create a drawing on a worksheet.*
• Insert a picture into a worksheet.*
• Use an Excel template to create a workbook.*
• Preview and save Excel data as a Web page.*
• Insert a hyperlink into a worksheet.
• Insert comments into a worksheet.

*These topics will be covered in classes only if time allows.

Microsoft offers certification in this subject, and depending on your position and duties, you may be eligible for reimbursement for the certification exam fee (currently around $75). View the exam objectives.