We're so confident of our products that we provide no hassle product exchange.
To pass the Microsoft 77-428 (Excel 2013 Expert Part Two) Certification Exam, candidates must demonstrate their proficiency in using Excel 2013’s advanced tools and features. They should have a deep understanding of advanced functions, formulas, and data manipulation tools, as well as an ability to create and use PivotTables, PivotCharts, and Macros. Passing this certification exam indicates that the candidate has the skills and knowledge required to use Excel 2013 for complex data analysis, reporting, and automation tasks. Furthermore, the certification demonstrates the candidate's commitment to their professional development and their dedication to staying current with the latest technologies and tools.
Microsoft 77-428 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Microsoft Excel 2013 Expert Part Two |
| Exam Number: | 77-428 |
| Exam Format: | Performance-based lab exam, Task-based simulation in Microsoft Excel 2013 |
| Passing Score: | 700 (on a 1000-point scale) |
| Real Exam Qty: | 35-50 (performance-based tasks) |
| 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) |
| Exam Price: | Approx. 100 USD (varies by region) |
| Related Certifications: | Microsoft Office Specialist Excel 2013 Expert Part One (77-427) Microsoft Office Specialist Excel 2013 |
| Exam Duration: | 50 minutes |
| 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 consists of a total of 40-60 questions, which must be completed within a time limit of 120 minutes. 77-428 exam questions are designed to test your knowledge of advanced Excel features, such as PivotTables, PivotCharts, and PowerPivot. In addition, the exam also covers topics such as data validation, advanced formulas and functions, and conditional formatting. 77-428 exam is available in multiple languages, including English, Chinese, French, German, Japanese, Portuguese, and Spanish.
Reference: https://www.microsoft.com/en-us/learning/exam-77-428.aspx
Obtaining the Microsoft 77-428 certification can open up many career opportunities for professionals in various industries. Employers value certification as it demonstrates the candidate's expertise and commitment to excel in their profession. Excel 2013 Expert Part Two certification can also lead to better job opportunities, higher salaries, and promotions. The Microsoft 77-428 certification is an excellent investment for professionals who want to advance their careers in the field of data analysis or business intelligence.
Microsoft 77-428 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Advanced Formulas and Functions | - Apply advanced logical and lookup functions - Troubleshoot formulas and errors - Use array formulas and nested functions |
| Advanced Formatting and Automation | - Apply conditional formatting with formulas - Use and manage macros (basic VBA awareness) - Customize workbook views and layouts |
| Collaboration and Security | - Protect workbooks, worksheets, and ranges - Manage shared workbooks and permissions - Track and review changes |
| Advanced Workbook Management | - Manage workbook properties and versions - Prepare workbooks for collaboration and distribution |
| Advanced Data Analysis | - Apply data consolidation and grouping techniques - Use advanced filtering and data validation - Use PivotTables and PivotCharts for analysis |
By Eric
