MSE-301: Microsoft Excel Level 3

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

Modules:

1. Customizing the Work Area
2. Advanced Formula Construction
3. Using Pivot Tables
4. Working with Multiple Worksheets
5. Consolidating and Analyzing Data
6. Using Protection and Display Options
7. Introduction to Macros
8. Working with Interactive Excel Web Documents