Microsoft 77-888 : Excel 2010 Expert Exam
The Microsoft 77-888 (Excel 2010 Expert) examination will cover intermediate to advanced knowledge of the features and functions of Microsoft Excel 2010. It is intended for
users who can manipulate data and options in order to analyze, enhance, and customize the environment, using advanced formulas, tools, and functions. The exam is only available in the English language.
Successful completion of the Microsoft 77-888 exam will earn participants the Microsoft Office Specialist: Microsoft Excel 2010 Expert certification. To prepare for this exam, candidates can purchase an online self-study training course, Skills Training in Microsoft Excel 2010. The 6-hour course will cover essential Excel processes and functions, all of which must be understood for the exam. Two practice tests are also available to take online.
Numerous topics will be tested in four key areas:
1. Presenting Data. Participants will be asked to apply such things as data analysis, advanced chart features, PivotCharts, and PivotTables to visually present data.
2. Maintaining Workbooks. Participants should be able to manage and maintain workbooks and worksheets by applying protection and sharing properties, data options, and settings.
3. Forms and Macros. Participants must have a clear understanding of the processes required to create/manipulate macros and insert/manipulate form controls.
4. Functions and Formulas. Knowledge of formula auditing, data summary tasks, manipulating formula options, and applying functions in formulas is required.