Microsoft Office Specialist (MOS) Excel Core MO-200
Prerequisites
Basic computer user skills and basic experience in the Microsoft Windows environment. We recommend 3 to 6 months of work experience.
About The Course:
The Microsoft Office Specialist: Excel Associate Certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges,
creating tables, applying formulas and functions and creating charts and objects.
The exam covers the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent
data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.
ACE College Credits
The American Council on Education’s College Credit Recommendation Service (ACE CREDIT®) approves Microsoft Certifications for ACE for credit transfer.
Official Microsoft Partner & Curriculum
Wincertification is an official Microsoft partner and uses the Official Microsoft Curriculum & Objectives. Our practice test and online labs are through GMetrix
Course length
The MOS Excel training is 15 clock hours. Training can be self-pace instructor driven or through classroom lectures. Students can take the course during evenings hours.
Testing
The MOS Excel MO-200 exam is 50 minutes: and 35 Questions and performed through Certiport. The Microsoft Office Specialist MOS Exam Voucher with Retake is $120
Manage Worksheets and Workbooks
1.1 Import data into workbooks
1.2 Navigate within workbooks
1.3 Format worksheets and workbooks
1.4 Customize options and views
1.5 Configure content for collaboration
Manage Data Cells and Ranges
2.1 Manipulate data in worksheets
2.2 Format cells and ranges
2.3 Define and reference named ranges
2.4 Summarize data visually
Manage Tables and Table Data
3.1 Create and format tables
3.2 Modify tables
3.3 Filter and sort table data
Perform Operations by using Formulas and Functions
4.1 Insert references
4.2 Calculate and transform data
4.3 Format and modify text
Manage Charts
5.1 Create charts
5.2 Modify charts
5.3 Format charts
