About This Exam
77-888: Microsoft Excel 2010 Expert Certification
Overview
The Microsoft Office Specialist (MOS) 77-888 exam certifies advanced expertise in Microsoft Excel 2010. This Expert-level certification demonstrates that candidates have mastered complex spreadsheet skills and can leverage Excel 2010's advanced features to analyze data, automate processes, and create sophisticated business solutions.
Exam Details
- Exam Name: Microsoft Excel 2010 Expert
- Exam Code: 77-888
- Certification Type: Microsoft Office Specialist (MOS) Expert
- Software Tested: Microsoft Excel 2010
- Exam Format: Performance-based testing in a live Excel environment
- Duration: 50 minutes
- Number of Questions: Approximately 25-30 complex tasks
- Passing Score: 700 (on a scale of 1-1000)
- Prerequisite: None officially required, but knowledge equivalent to the standard Excel 2010 exam (77-882) is recommended
Skills Measured
The 77-888 exam measures the candidate's ability to:
- Sharing and Maintaining Workbooks
- Apply workbook protection
- Maintain shared workbooks
- Save workbooks for distribution
- Configure and manage workbook versions
- Configure formula calculation options
- Applying Formulas and Functions
- Manipulate text with functions
- Work with logical operations in functions
- Apply advanced date and time functions
- Apply lookup and reference functions
- Apply mathematical functions
- Apply statistical functions
- Apply database functions
- Presenting Data Visually
- Create and modify advanced charts
- Apply and manipulate PivotTables
- Apply and manipulate PivotCharts
- Apply advanced conditional formatting
- Create and modify data visualizations
- Working with Macros and Forms
- Create and manipulate macros
- Create and modify form controls
- Configure macro security settings
- Implement data validation
- Data Analysis and Business Intelligence
- Use data analysis tools (What-If analysis, Goal Seek, Solver)
- Create and manipulate Table objects
- Manage large datasets using data tables and ranges
- Create and modify scenarios
- Consolidate data from multiple sources
- Create and manipulate subtotals
- Specialized Excel Functions
- Use financial functions
- Use array formulas
- Use specialized functions (SUMIFS, AVERAGEIFS, COUNTIFS)
- Trace precedents and dependents
- Create and use named ranges in complex formulas
Preparation Resources
Candidates preparing for the 77-888 exam can utilize various resources:
- Official Microsoft training materials specifically for Excel 2010 Expert level
- MOS Expert Study Guides
- Advanced Excel practice exams
- Instructor-led advanced Excel training courses
- Online advanced Excel tutorials and video courses
- Hands-on practice with complex datasets
Target Audience
This certification is ideal for:
- Financial analysts
- Data analysts
- Business intelligence professionals
- Accountants
- Business professionals who work extensively with data
- Excel power users
- Spreadsheet developers
- Administrative professionals seeking to demonstrate advanced skills
Value of Certification
Earning the MOS Excel 2010 Expert certification:
- Validates advanced technical expertise with Excel 2010
- Demonstrates the ability to solve complex business problems
- Distinguishes the candidate from those with only basic Excel skills
- May lead to increased job opportunities in data-intensive roles
- Shows commitment to professional development and excellence
- Can serve as a stepping stone to other advanced Microsoft certifications
Certification Path
The Excel 2010 Expert certification can be combined with other Office 2010 expert certifications to achieve the Microsoft Office Master 2010 certification, which requires:
- Excel 2010 Expert (77-888)
- Word 2010 Expert (77-887)
- PowerPoint 2010 (77-883)
- Plus one elective from: Outlook 2010 (77-884), Access 2010 (77-885), or SharePoint 2010 (77-886)
