Overview: Students will learn the skills and concepts necessary to work with advanced features of Excel 97.

Prerequisites: Windows 95: Introduction, and Excel 97: Worksheets, or equivalent knowledge.

Benefits: Students will learn how to customize toolbars, create pivot tables, link files, consolidate data, and record macros

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

• Customize toolbars and create styles and templates.
• Create nested and 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 Solver and Scenario Manager.
• Display and protect worksheet data by locking cells.
• Record and modify macros by using the Visual Basic Editor.

• Working with existing toolbars and creating new toolbars
• Creating and using styles
• Creating templates
• Nested functions
• The IF and VLOOKUP functions
• Error handling and the Auditing features
• Creating and working with pivot tables
• Linking individual cells
• Consolidating worksheets
• Using the Goal Seeker and Solver utilities
• Creating a scenario by using Scenario Manager
• Using comments
• Protecting the worksheet
• Hiding information and custom views