We may earn an affiliate commission when you visit our partners.
Phillip Burton • 850,000+ students so far and I Do Data Limited

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."

Read more

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.

Enroll now

What's inside

Learning objectives

  • 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

Syllabus

Introduction
Welcome to Udemy
How to get the best out of your Udemy course
Do you want auto-translated subtitles in more languages?
Read more
Introduction to the Microsoft Office Specialist: Associate certification
Word - Curriculum
Resources
Part 1 Section 1 - Insert text and paragraphs
131. Merge and split cells
An introduction to Microsoft Word
Fonts
Copy, cut and paste, dragging text, and the clipboard
101. Search for text
116. Find and replace text
117. Insert symbols and special characters
Practice Activity Number 1
Practice Activity Number 1 - The Solution
Part 1 Section 2 - Format text and paragraphs
118, 122. Apply text effects, including Clear Formatting
119. Apply formatting by using Format Painter
120. Set line and paragraph spacing
120. Set indentation
121. Apply built-in styles to text
Practice Activity Number 2
Practice Activity Number 2 - The Solution
Part 1 Section 3 - Configuring documents and creating document sections
123. Format text in multiple columns
104. Show and hide formatting symbols and hidden text
124. Insert page, section, and column breaks
105, 125. Set up document pages and Change page setup options for a section
Configuring documents and creating document sections
Practice Activity Number 3
Practice Activity Number 3 - The Solution
Part 2 Section 1 - Create and modify tables
128. Create tables by specifying rows and columns
126, 127. Convert text to tables, and tables to text (and how to add tabs)
132. Resize tables, rows, and columns
133, 134. Configure a repeating row header, and splitting tables
Practice Activity Number 4
Practice Activity Number 4 - The Solution
Formatting tables, including borders
129. Sort table data
130. Configure cell margins and spacing
Create and modify tables
Practice Activity Number 5
Practice Activity Number 5 - The Solution
Part 2 Section 2 - Create and modify lists
135, 136, 137. Format paragraphs as custom numbered and bulleted lists
139, 140. Set starting number values, and restart and continue list numbering
138. Increase and decrease list levels
Create and modify lists
Practice Activity Number 6
Practice Activity Number 6 - The Solution
Part 3 - Create and manage references
141. Insert footnote and endnotes
142. Modify footnote and endnote properties
143, 144. Create and modify citation sources, and citations
147. Insert bibliographies
145, 146. Insert and customize tables of contents
Create and manage references
Practice Activity Number 7
Practice Activity Number 7 - The Solution
Part 4 - Manage document collaboration
166-169. Comments
170, 173. Track changes and Lock and unlock change tracking
171, 172. Review, accept and reject tracked changes
Manage document collaboration
Practice Activity Number 8
Practice Activity Number 8 - The Solution
Part 5 Section 1 - Insert and format text boxes
153, 160, 163. Insert, add and modify text in text boxes, and position object
164. Wrap text around objects
165. Add alternative text to objects for accessibility
Insert and format text boxes
Practice Activity Number 9
Practice Activity Number 9 - The Solution
Part 5 Section 2 - Insert and Format Pictures
149. Insert pictures
155, 157. Apply picture effects and picture styles and Format graphic elements
154, 156. Apply artistic effects and Remove picture backgrounds
Insert and Format Pictures
Practice Activity Number 10
Practice Activity Number 10 - The Solution
Part 5 Section 3 - Insert and format other graphic elements
148. Insert shapes (including using the Canvas)
152. Insert screenshots and screen clippings
151, 158, 162. Insert, format and modify SmartArt graphic content
150, 159. Insert and format 3D models
Insert and format other graphic elements
Practice Activity Number 11
Practice Activity Number 11 - The Solution
Part 6 Section 1 - Navigate within and format documents
103. Move to specific locations and objects in documents
102. Link to locations within documents
106. Apply style sets
107. Insert and modify headers and footers
108. Configure page background elements

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Covers every skill required for the MO-100, MO-200, and MO-300 exams, providing a focused and structured approach to certification preparation
Includes practice activities and quizzes to reinforce learning, ensuring learners can confidently apply their new skills in real-world scenarios
Prepares learners to take the official Microsoft exams, which can lead to four Microsoft Office Specialist certifications, enhancing their professional credentials
Requires no prior knowledge, making it accessible to beginners who want to develop a strong foundation in Microsoft Word, Excel, and PowerPoint
Passing the official Microsoft exams may qualify American college students for college credit, offering an additional incentive for certification
Requires learners to pass three separate exams (Word, Excel, PowerPoint), which may require additional time and resources for scheduling and exam fees

Save this course

Save MO-100 Word, MO-200 Excel, MO-300 PowerPoint certifications to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MO-100 Word, MO-200 Excel, MO-300 PowerPoint certifications with these activities:
Review Basic Computer Skills
Reinforce fundamental computer skills to ensure a smooth learning experience with Microsoft Office applications.
Browse courses on File Management
Show steps
  • Review file management concepts.
  • Practice creating and organizing folders.
  • Familiarize yourself with common keyboard shortcuts.
Microsoft Office 365 and Excel 2019
Supplement course material with a comprehensive guide to Microsoft Office 365 and Excel 2019.
Show steps
  • Obtain a copy of the book.
  • Read relevant chapters corresponding to course topics.
  • Practice the techniques described in the book.
Practice Formatting Text in Word
Enhance proficiency in text formatting techniques within Microsoft Word to prepare for the MO-100 exam.
Show steps
  • Open a blank Word document.
  • Type several paragraphs of sample text.
  • Experiment with different font styles, sizes, and colors.
  • Adjust line spacing and paragraph indentation.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Follow Excel Formula Tutorials
Improve understanding of Excel formulas and functions by following online tutorials.
Show steps
  • Search for tutorials on specific Excel functions.
  • Follow along with the tutorial examples.
  • Apply the learned functions to your own data.
Microsoft PowerPoint Step by Step
Enhance PowerPoint skills with a step-by-step guide covering various aspects of presentation creation and delivery.
Show steps
  • Acquire the book.
  • Work through the step-by-step tutorials.
  • Apply the learned techniques to create your own presentations.
Create a PowerPoint Presentation on a Topic of Interest
Solidify PowerPoint skills by creating a presentation on a topic of your choice, incorporating various design elements.
Show steps
  • Choose a topic and gather relevant information.
  • Create an outline for your presentation.
  • Design visually appealing slides with text and images.
  • Add transitions and animations to enhance engagement.
Automate a Task with Excel Macros
Apply Excel skills to automate a repetitive task using macros, demonstrating practical application of course concepts.
Show steps
  • Identify a repetitive task in Excel.
  • Research how to automate the task using macros.
  • Record a macro to perform the task.
  • Test and refine the macro for efficiency.

Career center

Learners who complete MO-100 Word, MO-200 Excel, MO-300 PowerPoint certifications will develop knowledge and skills that may be useful to these careers:
Administrative Assistant
An Administrative Assistant relies heavily on software like Microsoft Word, Excel, and PowerPoint to perform daily tasks, such as document creation, data management, and presentation preparation. This course is highly relevant to an Administrative Assistant's role because it directly teaches the skills necessary to effectively use these programs. The course covers everything from basic text formatting in Word to advanced data manipulation in Excel and presentation design in PowerPoint. Those who wish to enter this career should take this course to build a strong foundation in the essential office tools that can set them apart from the competition.
Executive Assistant
An Executive Assistant relies on Microsoft Office tools, including Word, Excel, and PowerPoint daily. This course is perfect for individuals seeking a role as an Executive Assistant by providing extensive training on all of these programs. Through this course, a candidate can build a solid foundation in document creation, data handling, and presentation design, which are all critical for this career. If you would like to begin a career in this field, this course will give you a strong start.
Office Manager
An Office Manager is often responsible for creating and maintaining office documents, spreadsheets, and presentations. This course helps a prospective Office Manager gain proficiency in Word, Excel, and PowerPoint, which are essential software tools for this role. The course's focus on file management, table creation, data operations using formulas, and presentation design directly aid an Office Manager in performing their daily responsibilities. If you are interested in this career, this course will familiarize you with the tools you'll need to succeed.
Project Coordinator
A Project Coordinator benefits from strong skills in Microsoft Word, Excel, and PowerPoint for tasks like creating project documentation, tracking progress data, and generating reports. This course aids a Project Coordinator by teaching the tools necessary to effectively manage project information and present it clearly. The course delves into document collaboration, data analysis within Excel, and the creation of effective presentations, equipping a project coordinator with the essential skills to manage projects successfully. A Project coordinator should take this course to master the software tools they will use every day.
Sales Representative
A Sales Representative often uses Microsoft Word, Excel, and PowerPoint to create sales reports, presentations, and proposals. This course helps a prospective Sales Representative by enhancing their proficiency in these essential programs. The course’s instruction in document creation, data management, and presentation design directly aligns with the various types of materials a Sales Representative needs to create. If you are hoping to enter a career in sales, this course will give you the tools you need to create a strong sales package.
Training Coordinator
A Training Coordinator often creates training materials and presentations, necessitating proficiency in Word, Excel, and PowerPoint. This course is helpful for a Training Coordinator looking to produce engaging and effective training content. The course’s detailed instruction on document design, data management, and the creation of presentations helps a training coordinator to develop the skills they will need to excel within this career field. If you wish to begin a career in this field, this course will help you develop the skills you need to effectively create and manage training materials.
Business Analyst
A Business Analyst frequently makes use of data analysis and presentation tools, meaning that Microsoft Excel and PowerPoint are essential software for this role. This course helps a prospective Business Analyst learn how to manage data, create charts, and make presentations, and focuses on the specific skills that the role requires. This includes tasks such as using formulas and functions to manipulate data within Excel, and creating presentations to communicate complex data to various stakeholders. This course may be useful for those beginning a career as a business analyst.
Report Analyst
A Report Analyst frequently works with data, and must analyze and present their findings. This course may be helpful for a Report Analyst, as the course covers Microsoft Excel extensively, providing training in both data management skills as well as charting. The course's focus on using formulas and functions, as well as creating tables will enable you to create more effective analyses. This course is a great place to start for those seeking to move into this career.
Marketing Assistant
A Marketing Assistant uses Microsoft Office products, including Word, Excel, and PowerPoint, in their daily activities. This course may be useful for a Marketing Assistant as it covers the range of skills necessary for this particular job. Tasks such as creating marketing materials, managing data, and creating presentations are all supported by the knowledge imparted in this course. For a candidate seeking to enter this career, the course provides the skills to make them more effective on the job.
Curriculum Developer
A Curriculum Developer often uses Microsoft Word, Excel, and PowerPoint for creating educational materials and content. This course can be useful for Curriculum Developers as it teaches the range of skills needed to use these programs effectively. This includes document design, data analysis, and presentation creation. The ability to create effective learning materials is crucial for a curriculum developer, making this a good starting point for those intending to enter the field.
Consultant
A Consultant frequently uses Microsoft Office software to create reports, presentations, and data analysis documents. This course may be useful for a Consultant as it covers the range of skills required to use Word, Excel, and PowerPoint effectively. This includes the ability to create professional-looking documents, perform data analysis, and present findings in a persuasive manner. Consultants should consider taking this course to enhance their basic skills and increase their overall effectiveness.
Data Entry Clerk
A Data Entry Clerk uses tools like Microsoft Excel on a daily basis. This course may be useful because it covers key Excel skills such as data management, formulas, and functions. The detailed exploration of managing worksheets, data cells, and ranges, as well as the use of formulas for data manipulation, directly translates to the skill set of a Data Entry Clerk. If you seek to enter this career, this course will enhance your fundamental skills.
Research Assistant
A Research Assistant often uses Microsoft Word, Excel and PowerPoint when gathering and presenting research data. This course may be useful as it covers a range of tasks that a research assistant may engage in, from creating reports in Word; to managing data in Excel; to creating presentations using PowerPoint. This course can help a Research Assistant manage their work effectively. If you plan to enter into this career, consider this course as a way to familiarize yourself with essential software tools.
Content Creator
A Content Creator often needs to produce documents, charts, and presentations for a variety of purposes. This course may be useful for a Content Creator, teaching the skills necessary to use Microsoft Word, Excel, and PowerPoint. The course helps build a foundation in these programs, including skills in formatting and document design; data manipulation and analysis; as well as presentation creation that will benefit a content creator. Aspiring content creators should take this course as it covers the fundamentals of creating digital content.
Technical Writer
A Technical Writer produces detailed documents and reports that often require a deep understanding of word processing and related software. This course may be useful for a Technical Writer, as it provides comprehensive training in Microsoft Word, including managing documents, formatting text, and creating references. The course will help a Technical Writer enhance their ability to create highly formatted documents and manage collaborations with colleagues, making this course a strong entry into the field.

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in MO-100 Word, MO-200 Excel, MO-300 PowerPoint certifications.
Provides a comprehensive guide to using Microsoft Office 365 and Excel 2019. It covers a wide range of topics, from basic features to advanced techniques. It useful reference for both beginners and experienced users, and can help students deepen their understanding of the software.
Offers a step-by-step approach to learning Microsoft PowerPoint. It is designed for users of all levels, from beginners to advanced users. The book covers a wide range of topics, including creating presentations, adding multimedia, and delivering presentations effectively. It valuable resource for anyone who wants to improve their PowerPoint skills.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser