This course provides an overview of the MOS Excel Associate exam and covers the fundamentals of creating and managing worksheets as listed in the exam requirements. The course includes tips on how to do well on the test. Finally, the test includes exercises for each topic + test exercises that follow the pattern of questions asked in the MOS Excel Associate exam.
Microsoft provides everyone who scores 70% on the exam with the MOS Associate Excel, or Microsoft Office Specialist Associate Excel certification. This certification demonstrates your proficiency in Excel to your employer or potential employer and is a great asset in your work, career, and salary potential. All the best.
Become a Microsoft Office Specialist and Enhance Your Career
Use your knowledge to obtain certified status
Understand the MO-200 Exam
Learn how to correctly prepare for the test
Get advice from a seasoned professional who knows how to pass the exam
You will learn how to:
Manage worksheets and workbooks (10-15%)
Import data into workbooks
Navigate within workbooks
Format worksheets and workbooks
Customize options and views
Configure content for collaboration
Manage data cells and ranges (20-25%)
Manipulate data in worksheets
Format cells and ranges
Define and reference named ranges
Summarize data visually
Manage tables and table data (15-20%)
Create and format tables
Modify tables
Filter and sort table data
Perform operations by using formulas and functions (20-25%)
Insert references
Calculate and transform data
Format and modify text
Manage charts (20-25%)
Create charts
Modify charts
Format charts