Students will learn techniques for analyzing and manipulating data in Excel 2007. Upon successful completion of this course, participants will 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; 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.

Prerequisites: Intermediate competency with the Excel tool (e.g., working with charts and chart sheets, sorting, filtering and querying data).

$100