Course Information
Course Overview
Learn the skills for the MO-100 Word, MO-200 Excel, MO-300 PowerPoint Associate exams. Get Microsoft Office certified.
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.
Course Content
- 10 section(s)
- 231 lecture(s)
- Section 1 Introduction
- Section 2 Part 1 Section 1 - Insert text and paragraphs
- Section 3 Part 1 Section 2 - Format text and paragraphs
- Section 4 Part 1 Section 3 - Configuring documents and creating document sections
- Section 5 Part 2 Section 1 - Create and modify tables
- Section 6 Part 2 Section 2 - Create and modify lists
- Section 7 Part 3 - Create and manage references
- Section 8 Part 4 - Manage document collaboration
- Section 9 Part 5 Section 1 - Insert and format text boxes
- Section 10 Part 5 Section 2 - Insert and Format Pictures
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
Skills covered in this course
Reviews
-
BBrittany Appleby
Enjoyed the Word and Excel (though I have taken the intermediate Excel before this one) and I was excited how much I remembered. The PowerPoint portion wasn't the best but Powerpoint has a lot to it.
-
SShelley Strezo
yes, a lot of information
-
SStephen Akamumpa
perfect match
-
RRebecca Cividanes
This course was a fantastic way to learn about major Microsoft Office programs. The instructor teaches you how to use the programs, not just what you need to pass the certification exams. I would have personally liked to have more practice exams that mirror the way that the certification exams are run, i.e. their layout and what to expect. but overall I would recommend this course to anyone interested in learning Microsoft Word, Excel, or PowerPoint!