Why this course?

Description

The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidates are expected to demonstrate the correct application of the principal features of Excel at an expert-level and complete tasks independently.

This exam measures competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.

Skills measured

• Manage workbook options and settings (15-20%)
• Manage and format data (20-25%)
• Create advanced formulas and macros (30-35%)
• Manage advanced charts and tables (25-30%)

Examination Skills outline is attached in the Document Section