MO-100 Word, MO-200 Excel, MO-300 PowerPoint certifications
What you'll learn
- We will look at every skill required for the MO-100, MO-200 and MO-300 exams. This includes:
- Insert and format text, paragraphs, and sections, including how to use the Format Painter, and how to insert page, section and column breaks
- Manage tables and lists and create and manage references
- Insert and format graphic elements, which includes text boxes, pictures, SmartArt, screenshots, and 3D models.
- Manage document collaboration, namely managing comments and tracking changes to documents
- Manage worksheets, workbooks, data cells, ranges, tables, charts and using formulas and functions
- Manage presentations, slides, and applying transitions and animations
Requirements
- Before beginning, you will need to know how to use a Windows computer, including a mouse.
- It would be good if you have used Microsoft Word before, but this is not essential.
Description
Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist: Associate certification in multiple Office programs.
What do people like you say about this course?
Daniel says: "This lecturer is exceptional. Short and easy to understand segments. The subject is broken down into easy to digest pieces. The tests are excellent to revise what he has just taught you."
Jennifer says: "I have been using these programs for over twenty years, and I still learned a few things I hadn't discovered on my own. I passed the exams with flying colors. :) Great instructor, great course!"
Juan says: "Passed Word Exam with 1000 as a score."
Obtaining this requires passing 3 exams: the MO-100 Word exam, the MO-200 Excel exam, and the MO-300 PowerPoint exam. In this course, we'll take each in turn, and go through all of the requirements for each exam.
In the MO-100 Word part of this course, we'll be looking at:
Manage documents
Insert and format text, paragraphs, and sections
Manage tables and lists
Create and manage references
Insert and format graphic elements
Manage document collaboration
In the MO-200 Excel part of this course, we'll be looking at:
Manage worksheets and workbooks
Manage data cells and ranges
Manage tables and table data
Perform operations by using formulas and functions
Manage charts
In the MO-300 PowerPoint part of this course, we'll be looking at:
Manage presentations
Manage slides
Recapping how to Insert and format text, shapes, and images, tables, charts, smartArt, 3D models, and media – but we'll already have done most of the work in the Word part of this course.
Apply transitions and animations
No prior knowledge is required. And there are regular Practice Activities and quizzes to help you remember the information, so you can be sure that you are learning.
Once you have completed this course, you will have an expanded knowledge of Microsoft Word, Excel and PowerPoint. And with some practice, you could even take the official Microsoft exams, which will get you four Microsoft Office Specialist certifications – Word Associate, Excel Associate, PowerPoint Associate, and the overall Microsoft Office Specialist Associate. Wouldn't these official Microsoft certifications look good on your CV or resume? And if you are an American college student, you might even get college credit for passing each of these exams.
Who this course is for:
- This course is for you if you want to develop your Microsoft Word, Excel and PowerPoint skills.
- This course will use the 2019 Office edition, but is ideal for you if you use any modern version - 2007, 2010, 2013, 2019 or 365.
- This course is also for you if you use an older version of Microsoft Office, but want to learn the newer versions.
- This course is for you if you want to become certified in Microsoft Office, as we will be using the skills requirements of the Official Microsoft MO-100, MO-200 and MO-300 exams..
- This course is not for you if you want to learn Microsoft Office for Macintosh computers.
Instructors
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 630,000 students and more than 40 video courses, including over a dozen Bestseller courses.
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.
Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.
Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.
For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies.
That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job.
I Do Data courses are dedicated to enabling you to succeed.