Length of Course: 1 day

Overview:
This one-day course provides students with the skills and concepts necessary to create charts and to use the list-management capabilities of Microsoft Excel.

Prerequisites:
Prior to attending this class, students should have the following experience:

• Understanding of the basic concepts involved in working with a personal computer (PC)
• Familiarity with the Windows interface
• Microsoft Excel - Level 1 and Microsoft Excel - Level 2, or equivalent knowledge

Objectives:
Upon successful completion of this course, students should be able to:

• Customize toolbars and create styles and templates.
• Create decision-making functions.
• Analyze worksheet data by creating pivot tables.
• Compare and contrast workbook files and file links.
• Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.
• Display and protect worksheet data by locking cells.
• Record and modify macros by using the Visual Basic Editor.
• Create and work with interactive Web documents.