Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MOS Excel Associate Certification MO-200: Master Concepts
Rating: 4.3 out of 5(10 ratings)
57 students

MOS Excel Associate Certification MO-200: Master Concepts

Master Techniques to ace the MOS Excel Associate MO-200 Exam
Last updated 8/2022
English

What you'll learn

  • How to Successfully Pass the MOS Excel Associate 2019 Exam
  • Demonstrate your Excel skills to Potential Employers
  • Use Microsoft Excel for everyday business use
  • How to get the needed preparation for the MOS Excel Associate 2019 Exam

Course content

22 sections69 lectures2h 40m total length
  • Salient features of the MOS Excel Associate Certification Course1:47
  • About the MOS Excel Certification and this course2:57

    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.


Requirements

  • You must have Microsoft Excel 365/2019, preferably on a Windows computer.

Description

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

Who this course is for:

  • Beginner and Intermediate Excel users who want to Successfully Pass the MOS Excel Associate 2019 Exam