
I am not allowed to post the PDF of the MOS skills measured from Microsoft, but if you do a search for Microsoft Office Specialist Excel Associate skills measured, you'll find the PDF.
Please download and make a copy of the file, MOS Excel Associate 2019 Course.xlsx. The first sheet in this file contains links to each concept covered in this course. Each sheet contains the instructions and sequence of steps to be followed for implementing that concept. The videos cover the concept in more detail.
If you completed the practice exercises successfully, you may register for the test here.
My name is Prasad Hariharan. I've been interested in exploring productivity techniques for a long, long time. I've taught a few thousands of students, and realized that every student is unique. Everyone processes information differently. The same productivity techniques do not work for everyone. My goal is to introduce students to different productivity techniques that they can explore for themselves. When one is more productive, one can add more value to our world. That's my goal.
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