MOS Excel 2007 Expert

Course details

This is a Technical Specialist exam designed to assess candidates’ expert level handson skills in Microsoft Office Excel 2007. We are specifying an item pool of at least 125 unique items, which will be used across multiple pools. Items should be written to the Application cognitive level. For more information about cognitive levels, refer to the Cognitive Domain in Bloom’s Taxonomy.This exam is intended for candidates with the equivalent of more than one year of handson experience in efficiently utilizing advanced features of Microsoft Office Excel 2007. These skills include capturing,formatting, calculating, analyzing, and presenting data and managing automation, data ranges, and workbooks. The successful candidate might have the role of financial analyst, data analyst, or project manager.

Objective Domain

1. Capturing Data

• 1.1. Restrict data entry by using data validation.
• 1.2. Link form controls to cells.
• 1.3. Import data from an external source.
• 1.4. Link to data in an external source.

2. Calculating Data by Using Advanced Formulas

• 2.1. Create formulas that combine Lookup & Reference and Statistical functions.
• 2.2. Create formulas that combine Date & Time, Text, and Logical functions.
• 2.3. Manage and reference defined names.
• 2.4. Audit formulas.

3. Managing Data Ranges

• 3.1. Consolidate data ranges.
• 3.2. Select and manipulate similar cells and objects.
• 3.3. Apply advanced filtering.
• 3.4. Protect data in a worksheet.

4. Summarizing and Analyzing Data

• 4.1. Create PivotTables and PivotCharts.
• 4.2. Modify PivotTable content.
• 4.3. Perform whatif analysis.

5. Formatting Worksheet and Chart Content

• 5.1. Create custom number formats.
• 5.2. Define advanced conditional formatting rules by using formulas.
• 5.3. Add visual elements to a chart.

6. Managing Macros and User-Defined Functions

• 6.1. Record and edit a macro.
• 6.2. Manage existing macros.
• 6.3. Create a userdefined function (UDF).