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.
Microsoft 77-428 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel 2013 Expert Part Two |
| Exam Number: | 77-428 |
| Passing Score: | 700 / 1000 |
| Exam Price: | $100–$150 USD (varies by region) |
| Exam Duration: | 50 minutes |
| Related Certifications: | Microsoft Office Specialist 2013 Master |
| Exam Format: | Project-based, Performance-based, Live application simulation |
| Real Exam Qty: | 40-50 |
| Available Languages: | Italian, Chinese (Traditional), Spanish, Korean, Chinese (Simplified), German, French, Dutch, Russian, Portuguese (Brazil), Arabic (Saudi Arabia), Japanese |
| Certificate Validity Period: | Lifetime (no expiration) |
| Recommended Training: | Microsoft Official Learning Resources MOS Excel 2013 Expert Study Guide |
| Exam Registration: | Microsoft Official Exam Page Certiport Registration |
| Exam Way: | Online proctored or on-site at Certiport authorized testing centers |
| Pre Condition: | Pass Exam 77-427: Microsoft Excel 2013 Expert Part One |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/77-428/ |
How to Register For Exam 77-428: Microsoft Excel 2013 Expert Part Two?
Exam Register Link: https://www.certiport.com/locator
Reference: https://www.microsoft.com/en-us/learning/exam-77-428.aspx
Microsoft 77-428 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Create Advanced Charts and Tables | 20% | - Create and modify advanced charts - Create and customize PivotCharts - Format tables and manage data models - Work with Power View and data connections - Build and manage PivotTables |
| Topic 2: Apply Custom Formats and Layouts | 25% | - Customize page setup and print options - Create and modify custom templates - Create and apply custom number formats - Apply advanced conditional formatting - Manage cell styles and themes |
| Topic 3: Manage and Share Workbooks | 25% | - Manage workbook versions and history - Share and collaborate on workbooks - Manage macros and add-ins - Export and publish workbooks - Apply workbook security and protection |
| Topic 4: Create Advanced Formulas | 30% | - Use database and text functions - Work with financial and statistical functions - Create nested and array formulas - Use logical and lookup functions - Troubleshoot and audit formulas |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
0 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.