
Master Microsoft Office basics across Word, Excel, and PowerPoint with practical exercises, quizzes, and exam prep to build confidence in documents, spreadsheets, and presentations.
Navigate Udemy courses efficiently by mastering playback controls, speed, volume, captions, and quality, then access course content, notes, announcements, and certificates to prepare for Word, Excel, and PowerPoint exams.
Prepare for the MO-100 Word, MO-200 Excel, and MO-300 PowerPoint exams to earn the Microsoft Office Specialist Associate certification for Office 365 and Office 2019 after completing all three.
Navigate the six MO-100 Word competencies—managing documents; inserting and formatting text, paragraphs, and sections; managing tables and lists; creating and managing references; inserting and formatting graphics; and managing document collaboration.
Explore the Microsoft Word interface, from the home ribbon and templates to open, save, and print options, and understand tool groups and search features.
Discover how to use the fonts section on the home tab to change font style and size with live previews, including serif versus sans serif distinctions and quick size adjustments.
Demonstrates copy, cut, and paste using the clipboard, how to paste with formatting options, and dragging text to move without the clipboard; includes Ctrl+C, Ctrl+V, Ctrl+X.
Learn to search for text in a document using Word's find tool and navigation pane. Use advanced find options, whole words only, and the ctrl+f shortcut for efficient searching.
Learn to use find and replace in Word with the replace dialog, replace all, undo, redo, and options like match case, find whole words, and find all word forms.
Learn to insert symbols and special characters in documents using auto correct, insert symbol, and keyboard shortcuts like ctrl+5 and ctrl+comma. Explore accents, cedilla, umlaut, wingdings, and other character options.
Practice activity demonstrates essential Word skills: selecting paragraphs, copying, cutting, pasting, highlighting text, using find and replace, undo/redo, inserting symbols, and applying font changes.
Explore applying text effects to format text and paragraphs, adjusting bold, italic, underline, font color, and color pickers, plus shadows, outlines, ligatures, and case transformations, with clear formatting.
Learn to set line and paragraph spacing in a Word document by adjusting line spacing options and paragraph spacing before and after. Use the spacing dialogue box for exact values.
Explore how to set indentation in paragraphs by adjusting left, right, and first-line indents, using the ruler and paragraph settings to achieve justified and hanging indents.
Apply built-in text styles to format chapters and sections with heading one and heading two, and explore the styles pane to view or modify styles, returning to normal when needed.
Practice activity two demonstrates applying Word formatting—blue font, yellow background, font size 20, Arial—with headings and indentation, plus using the format painter and line spacing.
Insert and manage page, section, and column breaks using layout and page setup to control text flow, with options for continuous or next page breaks and even/odd pages.
Set up document pages with margins, orientation, paper size, and vertical alignment, and use section breaks to enable different layouts for a section or the whole document.
Master Word formatting via practice activity 3: two-column layouts with a middle line, hidden text with show/hide formatting, page and section breaks, ledger size, and landscape orientation for MO-100 prep.
Learn to create and format tables by specifying rows and columns, using insert table or draw table, and choosing fit options for contents or window.
Convert text to a table in Word using tabs as delimiters, then convert the table back to text. Learn to adjust tab stops and auto fit.
Insert and resize table elements using table layout controls, plus signs, and ruler; delete columns or rows, select multiple columns, and navigate with tab and shift-tab.
Select the header row, use table layout repeat header rows to repeat on subsequent pages, and insert a page break or split the table to control where the table breaks.
Convert tab-separated text into a table, fit to contents, repeat header rows, remove extra carriage returns, and save with a new file name.
Master table styling with shading and borders, adjust colors and thickness, apply page borders, and manage repeating header rows through borders and shading settings.
Learn how to merge and split cells in tables, selecting cells, two columns by one row, and the context menu, and understand when to apply each.
Sort a Word table by cost, number, text, or date using table layout, sort options, and header row settings, with case sensitivity controls.
Learn to configure cell margins and cell spacing in tables, using table layout, adjust alignment and text wrapping, and understand default cell margins and unit measurements.
Practice activity demonstrates sorting a table by item name and cost, inserting and merging cells, adjusting margins and borders, shading the header, and converting between table and text in Word.
Create and customize numbered and bulleted lists in word processing, using the split button to apply formats and auto renumbering, define new bullets, and explore alignment options.
Learn how to start a list at a specific number using set numbering value, restart numbering, and continue from previous lists, avoiding unintentional list merging in Word.
Practice activity 6 guides you to create bulleted and numbered lists, including heart bullets, font size 16, and right alignment. It also covers multi-level lists, indent, restart numbering, and unindent.
Learn to insert footnotes and endnotes via the references tab, with footnotes at page bottom and endnotes at the document end, using Ctrl+Alt+F and Ctrl+Alt+D.
Discover how to configure footnotes and endnotes in Word via the References dialog. Manage placement, numbering formats, and custom marks, and navigate between notes.
Insert and edit citation sources, create bibliographies, and manage citations with fields, placeholders, and page-specific edits across different styles, including Harvard and IEEE.
Insert a bibliography from references, choose a style, and update citations and bibliography to reflect edited sources, new sources, and alphabetical ordering.
Insert and customize a table of contents by applying heading styles (heading one, two, and three), then use built-in options to format, print, and update it with hyperlinks.
Learn to add, reply to, resolve, reopen, and delete comments to foster document review. Navigate comments and toggle between all markup and simple markup to control visibility.
Enable track changes from the review tab to view edits with simple markup, all markup, or balloons, and lock tracking with a password.
Learn how to review tracked changes using the viewing pane and balloons, and efficiently accept or reject edits, comments, and formatting while managing track changes and author colors.
Explore document collaboration in Word through practice activity, showing how to add and reply to comments, and manage track changes with simple, no, or original markup views.
Explore how text wraps around objects like text boxes in Word, choosing to push text aside, place the shape behind text, or lock the shape to a fixed position.
Describe shapes, pictures, and text boxes with alt text to support screen readers, and mark decorative elements to signal nonessential content in Word and on the web.
Insert a simple text box in practice activity 9, adjust wrapping, set layering, add alt text, edit the text, and center align from the home tab.
Learn to insert pictures from device, stock images, or online pictures via Bing; understand licensing, and adjust size, wrap text, and picture format in your document.
Apply picture effects and styles to add borders, shadows, and 3D rotation while adjusting brightness, contrast, color saturation, tone, and cropping for optimized Word, Excel, or PowerPoint graphics.
Apply artistic effects like marker, pencil, line drawing, chalk sketch, or paint strokes to photos, and remove backgrounds using color set or the built-in remove background tool with transparency options.
Insert a stock image, resize to four inches, soften 25% and increase contrast 20%, apply a simple white frame, remove background, and apply pencil grey scale.
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.