Course Objectives: Advanced Microsoft Excel 2003

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

• Restrict cell entries to specific numbers, dates, or times.
• Restrict cell entries to specific entries in a list.
• Create a custom number format.
• Apply conditional formatting to a worksheet.
• Define a range name.
• Use a range name in a formula.
• Use the VLOOKUP and HLOOKUP functions.
• Create a new workbook template.
• Modify the default workbook template style.
• Trace precedents and dependents in a worksheet.
• Trace errors in a worksheet.
• Enter a formula to link multiple workbooks.
• Create a workspace.*
• Sort the records of a list.
• Add subtotals to a list.
• Outline a worksheet.*
• Create a PivotTable report and a PivotChart report..
• Create and display a scenario.
• Import external data into Excel.
• Export Excel data to other applications.*
• Track changes in a workbook.
• Respond to proposed changes and comments in a workbook.*
• Protect a shared workbook and an unshared workbook.*
• Add a trendline to a chart.*
• Save an Excel workbook as an XML spreadsheet.

*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.