MOS Excel Expert
irna
Thu, 12/14/2023 - 04:42
Duration
3 Days
Exam Details
- Exam Code:
Exam MO-201: Microsoft Excel
Expert (Excel and Excel 2019) - Skills measured:
o Manage workbook options and settings (15-20%)
o Manage and format data (20-25%)
o Create advanced formulas and macros (30-35%)
o Manage advanced charts and tables (25-30%)
Price
--- Call Us ---
Demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Expert Certification. This certification demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry expert-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel at an expert-level and can complete tasks independently.
Objectives
- Manage workbook options and settings
o Manage workbooks
o Prepare workbooks for collaboration
o Use and configure language options - Manage and format data
o Fill cells based on existing data
o Format and validate data
o Apply advanced conditional formatting and filtering - Create advanced formulas and macros
o Perform logical operations in formulas
o Look up data by using functions
o Use advanced date and time functions
o Perform data analysis
o Troubleshoot formulas
o Create and modify simple macros - Manage advanced charts and tables
o Create and modify advanced charts
o Create and modify PivotTables
o Create and modify PivotCharts
Contact
- Nurman (+62 857-2375-3840)
- Irna (+62 822-1664-7749)
- Puji (+62 813-2424-2115)
- Shafa (+62 813-9049-0664)