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:
- Customizing the Work Area
- Advanced Formula Construction
- Using Pivot Tables
- Working with Multiple Worksheets
- Consolidating and Analyzing Data
- Using Protection and Display Options
- Introduction to Macros
- Working with Interactive Excel Web Documents