This course provides an overview of the MOSExcel 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 MOSExcel 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