Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

MO-100 Word, MO-200 Excel, MO-300 PowerPoint exam prep

via Udemy

Overview

Learn the skills for the MO-100 Word, MO-200 Excel, MO-300 PowerPoint Associate exams. Get Microsoft Office certified.

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

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.

Please note:This course is not affiliated with, endorsed by, or sponsored by Microsoft.


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.

Syllabus

  • Introduction
  • Part 1 Section 1 - Insert text and paragraphs
  • Part 1 Section 2 - Format text and paragraphs
  • Part 1 Section 3 - Configuring documents and creating document sections
  • Part 2 Section 1 - Create and modify tables
  • Part 2 Section 2 - Create and modify lists
  • Part 3 - Create and manage references
  • Part 4 - Manage document collaboration
  • Part 5 Section 1 - Insert and format text boxes
  • Part 5 Section 2 - Insert and Format Pictures
  • Part 5 Section 3 - Insert and format other graphic elements
  • Part 6 Section 1 - Navigate within and format documents
  • Part 6 Section 2 - Save and share documents, and inspect documents for issues
  • Well done for finishing the Word course
  • Introduction to Excel MO-200
  • Part 7 Section 1 - Import data into workbooks and Navigate within workbooks
  • Part 7 Section 2 - Format worksheets and workbooks
  • Part 7 Section 3 - Customize options and views
  • Part 7 Section 4 - Configure content for collaboration
  • Part 8 Section 1 - Manipulate data in worksheets
  • Part 8 Section 2 - Format cells and ranges
  • Part 8 Section 3 - Summarize data visually
  • Part 9 Section 1 - Create and format tables
  • Part 9 Section 2 - Filter and sort table data
  • Part 10 Section 1 - Creating formulas
  • Part 10 Section 2 - Calculate and transform datas
  • Part 10 Section 3 - Define and reference named ranges
  • Part 10 Section 4 - Format and modify text
  • Part 11 Section 1 - Create and modify charts
  • Part 11 Section 2 - Format charts
  • Well done for finishing the Excel course
  • Introduction to PowerPoint MO-300
  • Part 12 Section 1 - Insert slides
  • Part 12 Section 2 - Modify slides
  • Part 12 Section 3 - Skills from the MO-100 course
  • Part 12 Section 4 - Order and group slides
  • Part 13 Section 1 - Order and group objects on slides
  • Part 13 Section 2 - Manage media
  • Part 14 Section 1 - Apply and configure slide transitions and animations
  • Part 14 Section 2 - Modify slide, handout and note masters, and print
  • Part 14 Section 3 - Configure and present slide shows, prepare for collaboration
  • Well done for finishing the PowerPoint course
  • Bonus Lecture

Taught by

Phillip Burton • over one million students so far and I Do Data Limited

Reviews

4.7 rating at Udemy based on 377 ratings

Start your review of MO-100 Word, MO-200 Excel, MO-300 PowerPoint exam prep

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.