We're so confident of our products that we provide no hassle product exchange.
Other Microsoft Certifications Available
Passing the Microsoft MO-201 test and attaining the Microsoft Office Specialist: Expert (Office and Office 2019) or Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) is not the final point of this career track. After earning them, you may want to add more competencies and broaden your skill set by choosing another relevant exams that complies with the Microsoft Office Specialist: Expert certification path. And your best options here include going for the Microsoft Office Specialist: Microsoft Word 2016 Expert, Microsoft Office Specialist: Microsoft Access Expert (Access and Access 2019), and other relevant certificates.
About the Microsoft MO-201 Exam
The Microsoft MO-201 exam addresses a candidate's ability to modify Excel environments to satisfy business needs. Thus, the candidates should be familiar with a ton of workbook examples such as amortization tables, inventory schedules, and business templates, among the rest. Since this exam is a requirement for the expert-level certificates, you should have a solid understanding of the principal Excel features at an advanced level and the ability to complete the required tasks independently when applying for it.
Microsoft MO-201 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel Expert (Excel and Excel 2019) |
| Exam Number: | MO-201 |
| Exam Duration: | 50 minutes |
| Exam Format: | Hands-on simulation, Project-based tasks, Performance-based |
| Certificate Validity Period: | Valid for lifetime |
| Available Languages: | Chinese (Traditional), Japanese, German, Chinese (Simplified), French, Korean, Spanish, English |
| Related Certifications: | Microsoft Office Specialist: Expert (Office 2019) |
| Exam Price: | USD 100* (varies by region) |
| Passing Score: | 700 / 1000 |
| Real Exam Qty: | 5-6 project scenarios / approx. 25-30 tasks |
| Recommended Training: | Microsoft Official Learning Path |
| Exam Registration: | Microsoft Learn MO-201 Page Certiport Registration |
| Sample Questions: | Microsoft MO-201 Sample Questions |
| Exam Way: | Online proctored or in-person at authorized Certiport test centers |
| Pre Condition: | No mandatory prerequisites; recommended 150+ hours of hands-on Excel experience; completion of MO-200 (Excel Associate) is helpful but not required |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/mo-201/ |
Microsoft MO-201 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage and format data | 20-25% | - Import, transform, and consolidate data - Apply custom formatting and layouts - Manage data tables and ranges |
| Topic 2: Manage workbook options and settings | 15-20% | - Manage workbook review and protection - Configure workbooks - Configure workbook and language options |
| Topic 3: Manage advanced charts and tables | 25-30% | - Create and manage PivotTables - Create and modify advanced charts - Create and modify PivotCharts |
| Topic 4: Create advanced formulas and macros | 30-35% | - Apply functions in formulas - Use logical and statistical functions - Create and modify simple macros - Look up data using functions |
By Donald
