We're so confident of our products that we provide no hassle product exchange.
Exam 77-428: Microsoft Excel 2013 Expert Part Two
Expert-level candidates for the Excel 2013 exam should have an advanced understanding of the Excel environment and the ability to guide others in the proper use of features in Excel 2013 of Office Professional Plus. They should know and be able to demonstrate the use of advanced and specialized features within the application.
Candidates should be able to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations, and they should know how to customize their Excel environment to meet needs and enhance productivity. Workbook examples include custom business templates, multiple axis financial charts, amortization tables, and inventory schedules. Candidate roles might include accountants, financial analysts, data analysts, commercial bankers, and others.
Part of the requirements for: Microsoft Office Specialist: Excel 2013 Expert Microsoft Office Specialist 2013 Master
Schedule exam
Languages: English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Italian, Japanese, Korean, Dutch, Portuguese (Brazil), Russian, Arabic (Saudi Arabia)
Retirement date: none
Expert-level candidates for the Excel 2013 exam should have an advanced understanding of the Excel environment and the ability to guide others in the proper use of features in Excel 2013 of Office Professional Plus.
Reference: https://www.microsoft.com/en-us/learning/exam-77-428.aspx
Microsoft 77-428 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Microsoft Excel 2013 Expert Part Two |
| Exam Number: | 77-428 |
| Exam Duration: | 50 minutes |
| Available Languages: | English, Japanese, Spanish, French, German, Portuguese (Brazil), Simplified Chinese |
| Certificate Validity Period: | No fixed expiration (MOS certifications are generally non-expiring for 2013 series) |
| Related Certifications: | Microsoft Office Specialist Excel 2013 Expert Part One (77-427) Microsoft Office Specialist Excel 2013 |
| Passing Score: | 700 (on a 1000-point scale) |
| Exam Format: | Performance-based lab exam, Task-based simulation in Microsoft Excel 2013 |
| Exam Price: | Approx. 100 USD (varies by region) |
| Real Exam Qty: | 35-50 (performance-based tasks) |
| Recommended Training: | Microsoft Learn Excel resources Certiport MOS study materials |
| Exam Registration: | Certiport Official Registration Microsoft Credentials Portal |
| Exam Way: | Proctored exam delivered at authorized testing centers or online via Certiport (availability depends on region) |
| Pre Condition: | Recommended: Microsoft Office Specialist Excel 2013 (77-420 or equivalent foundational Excel knowledge) |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-expert/ |
Microsoft 77-428 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Advanced Workbook Management | - Prepare workbooks for collaboration and distribution - Manage workbook properties and versions |
| Topic 2: Advanced Formulas and Functions | - Use array formulas and nested functions - Troubleshoot formulas and errors - Apply advanced logical and lookup functions |
| Topic 3: Advanced Formatting and Automation | - Apply conditional formatting with formulas - Customize workbook views and layouts - Use and manage macros (basic VBA awareness) |
| Topic 4: Collaboration and Security | - Track and review changes - Manage shared workbooks and permissions - Protect workbooks, worksheets, and ranges |
| Topic 5: Advanced Data Analysis | - Use PivotTables and PivotCharts for analysis - Apply data consolidation and grouping techniques - Use advanced filtering and data validation |
By Kent
