cart-icn

You already have a course in your cart

You can only add one course to your cart at a time! By adding this course, you will replace the existing course from your cart. How would you like to proceed?

Microsoft Office Specialist (MOS) Associate Certification Training

The Microsoft Office Specialist (MOS) Associate Certification Training course will prepare you to take the Microsoft Office Specialist certification exams for Word, Excel, PowerPoint, and Outlook.

office-2019-master-cert-training
$2,059.00 (USD)

currency dollar icon
Payment & Funding: view your options
arrow right icon
Have a question?We're here to help
Back
customer service representatives

Explore your payments options

When it comes to paying for your course-you've got options! Schedule a call with us and we can help you find the payment method that works best for you.
credit card icon

Credit Card: Visa, Mastercard, Discover or American Express card Most Popular

affirm icon Affirm:

wallet icon

TuitionFlex: Low-interest monthly payments

building icon

Workforce Funding: Learn about eligibility

start icon

Military Benefits: Find out if your benefits apply

close icon

Overview

Objective

Outline

    Part 1 - Introduction to Microsoft Excel Training

    Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

    • Logging in to Microsoft 365
    • Installing Applications
    • Creating New Files and AutoSaving
    • Protected View
    • File Sharing
    • File Collaboration
    • Version History
    • Getting Updates
    • Mac Versions

    Lesson 2: Creating a Microsoft Excel Workbook - Quizzes: 1, Assignments: 1

    • Starting Microsoft Excel
    • Creating a Workbook
    • Saving a Workbook
    • The Status Bar
    • Adding and Deleting Worksheets
    • Copying and Moving Worksheets
    • View Options for the Worksheet
    • Closing a Workbook

    Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

    • Tabs
    • Groups and Commands
    • Microsoft Search Box
    • Customizing the Ribbon

    Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3

    • Introduction to the Backstage View
    • Opening a Workbook
    • New Workbooks and Excel Templates
    • Printing Worksheets
    • Personalizing Microsoft Office

    Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

    • Getting Started
    • Adding Common Commands
    • Adding Additional Commands with the Customize Dialog
    • Adding Ribbon Commands or Groups

    Lesson 6: Entering Data in Microsoft Excel Worksheets - Quizzes: 1, Assignments: 2

    • Entering Text
    • Inserting and Deleting Cells
    • Inserting Hyperlinks
    • Inserting WordArt
    • Using AutoComplete
    • Entering Numbers and Dates
    • Using the Fill Handle

    Lesson 7: Formatting Microsoft Excel Worksheets - Quizzes: 1, Assignments: 4

    • Selecting Ranges of Cells
    • Hiding Worksheets
    • Adding Color to Worksheet Tabs
    • Adding Themes to Workbooks
    • Adding a Watermark
    • The Font Group
    • The Alignment Group
    • The Number Group

    Lesson 8: Editing Worksheets - Quizzes: 1, Assignments: 2

    • Find
    • Find and Replace
    • Using the Clipboard
    • Moving Columns / Rows

    Lesson 9: Working with Rows and Columns - Quizzes: 1, Assignments: 1

    • Inserting and Deleting Rows, Columns, and Cells
    • Transposing Rows and Columns
    • Row Height and Column Width
    • Hiding and Unhiding Rows and Columns
    • Freezing Panes

    Lesson 10: Using Formulas in Microsoft Excel - Quizzes: 1, Assignments: 1

    • Math Operators and the Order of Operations
    • Entering Formulas
    • AutoSum (and Other Common Auto-Formulas)
    • Copying Formulas
    • Relative, Absolute, and Mixed Cell References

    Lesson 11: Finalizing Microsoft Excel Worksheets - Quizzes: 1, Assignments: 1

    • Setting Margins
    • Setting Page Orientation
    • Setting the Print Area
    • Print Scaling (Fit Sheet on One Page)
    • Repeating Headings
    • Headers and Footers

    Lesson 12: Using Copilot in Microsoft Excel - Quizzes: 1, Assignments: 1

    • Copilot in Microsoft 365 Excel
    • Creating Columns
    • Analyzing Your Data
    • Importing and Framing Data

    Introduction to Microsoft Excel Exam

    Part 2 - Intermediate Microsoft Excel Training

    Lesson 1: Common Functions - Quizzes: 1, Assignments: 7

    • Using Named Ranges in Formulas
    • Using Formulas That Span Multiple Worksheets
    • Functions: IF and IFS
    • Functions: AND and OR
    • Functions: NOT
    • Functions: SWITCH
    • Functions: COUNTIF, AVERAGEIF, and SUMIF
    • Functions: PMT and NPER
    • Functions: TEXTJOIN and CONCAT
    • Text Functions
    • Date and Time Functions

    Lesson 2: Working with Lists - Quizzes: 1, Assignments: 4

    • What is a List of Data?
    • Removing Duplicates from a List
    • Sorting Data in a List
    • Filtering Data in a List
    • Adding Subtotals to a List

    Lesson 3: Visualizing Your Data - Quizzes: 1, Assignments: 2

    • Chart Basics
    • Tools for Editing Charts
    • The Format Tool Tab
    • Using the Three Chart Buttons
    • The Format Task Pane
    • Useful Charts
    • Line and Area Charts
    • Hierarchy Charts
    • Statistic Charts
    • Other Charts
    • Combo Charts
    • Using Recommended Charts
    • Sparklines
    • Add and Format Objects
    • Working with Shapes
    • Working with Icons
    • Working with SmartArt
    • Using the Quick Analysis Tool

    Lesson 4: Working with Tables - Quizzes: 1, Assignments: 1

    • Format Data as a Table
    • Table Design Tool Tab
    • Formatting Individual Cells
    • Selecting Table Rows and Columns
    • Structured References
    • Convert a Table to a Range

    Lesson 5: Advanced Formatting - Quizzes: 1, Assignments: 2

    • Cell Styles
    • Conditional Formatting
    • Conditional Formatting: Highlight Cells Rules
    • Conditional Formatting: Top/Bottom Rules
    • Conditional Formatting: Data Bars, Color Scales, and Icon Sets
    • Conditional Formatting: Create a New Rule
    • Removing Conditional Formatting

    Intermediate Microsoft Excel Exam

    Part 3 - Advanced Microsoft Excel Training

    Lesson 1: Using PivotTables - Quizzes: 1, Assignments: 1

    • How PivotTables Work
    • Timeline Filters
    • Inserting Slicers
    • Grouping Data
    • Calculated Fields
    • PivotCharts

    Lesson 2: Advanced Functions - Quizzes: 1, Assignments: 2

    • Function Syntax
    • ROWS, COLUMNS, INDEX, and XMATCH
    • Arrays and Array Formulas
    • SORT, FILTER, and SORTBY
    • Lookup Functions
    • The LET Function
    • The TRANSPOSE Function

    Lesson 3: Auditing Workbooks - Quizzes: 1, Assignments: 1

    • Inspecting a Workbook
    • Tracing Precedents and Dependents
    • Watch Window
    • Evaluating Formulas
    • Error Checking

    Lesson 4: Data Tools - Quizzes: 1, Assignments: 5

    • Importing Data from Online Source
    • Converting Text to Columns
    • Importing Files
    • Linking to External Data
    • Controlling Calculation Options
    • Data Validation
    • Consolidating Data
    • What-If Analysis

    Lesson 5: Recording and Using Macros - Quizzes: 1, Assignments: 2

    • Recording Macros
    • Running Macros
    • Editing Macros
    • Adding Macros to the Quick Access Toolbar

    Lesson 6: Working with Others - Quizzes: 1, Assignments: 1

    • Comments and Notes
    • Protecting Worksheets and Workbooks
    • Marking a Workbook as Final
    • Other Sharing Concerns

    Advanced Microsoft Excel Exam, Final Microsoft Excel Exam

    Part 4 - Introduction to Microsoft Word Training

    Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

    • Logging in to Microsoft 365
    • Installing Applications
    • Creating New Files and AutoSaving
    • Protected View
    • File Sharing
    • File Collaboration
    • Version History
    • Getting Updates
    • Mac Versions

    Lesson 2: Creating a Microsoft Word Document - Quizzes: 1, Assignments: 1

    • Starting Microsoft Word
    • Creating a Document
    • Saving a Document
    • The Status Bar
    • Closing a Document
    • Opening Documents

    Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

    • Tabs
    • Groups and Commands
    • Microsoft Search Box
    • Customizing the Ribbon

    Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3

    • Introduction to the Backstage View
    • Opening a Document
    • New Documents and Word Templates
    • Configuring Documents to Print
    • Adding Your Name to Microsoft Word
    • Adding Values to Document Properties

    Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

    • Getting Started
    • Adding Common Commands
    • Adding Additional Commands with the Customize Dialog
    • Adding Ribbon Commands or Groups

    Lesson 6: Formatting Microsoft Word Documents - Quizzes: 1, Assignments: 7

    • Selecting Text
    • Fonts
    • Working with Lists
    • Inserting a Hyperlink in a Document
    • Using Styles
    • Using Themes
    • Using the Ruler
    • Indentation
    • Setting Margins
    • Special Characters
    • WordArt
    • Page Background Elements

    Lesson 7: Editing Documents - Quizzes: 1, Assignments: 2

    • Find
    • Find and Replace
    • Using the Clipboard
    • Search Options
    • Inserting Text from Another File

    Lesson 8: Finalizing Microsoft Word Documents - Quizzes: 1, Assignments: 3

    • Adding Page Numbers
    • Headers and Footers
    • Microsoft Editor
    • Checking Spelling and Grammar
    • Internationalization and Accessibility

    Lesson 9: Using Copilot in Microsoft Word

    • Copilot in Microsoft 365 Word
    • Highlighting Existing Text
    • Copilot Sidecar
    • Temporary Chat
    • Practical ways to use Copilot

    Introduction to Microsoft Word Exam

    Part 5 - Intermediate Microsoft Word Training

    Lesson 1: Advanced Formatting - Quizzes: 1, Assignments: 3

    • Shading and Borders
    • Setting Line and Paragraph Spacing
    • Changing Styles
    • Paragraph Marks and Other Formatting Symbols
    • Character Space Options
    • Changing the Default Font
    • Custom Design Elements
    • Editing PDF Documents in Microsoft Word

    Lesson 2: Working with Tables - Quizzes: 1, Assignments: 3

    • Inserting a Table
    • Converting Tables to Text
    • Sorting Table Data
    • Setting Cell Margins
    • Modifying Table Dimensions
    • Merging and Splitting Cells
    • Applying Formulas to a Table
    • Table Styles
    • Manipulating Rows, Columns, and Cells

    Lesson 3: Working with Images - Quizzes: 1, Assignments: 3

    • Inserting Images
    • Placing and Sizing Images
    • Wrapping Text around an Image
    • Adjusting Images
    • Borders and Effects
    • Using Live Layout and Alignment Guides

    Lesson 4: Page Layout - Quizzes: 1, Assignments: 2

    • Orientation and Paper Size
    • Working with Columns
    • Page and Section Breaks
    • Adding Titles to Sections
    • Hyphenation
    • Line Numbers

    Lesson 5: Working with Illustrations - Quizzes: 1, Assignments: 5

    • Adding and Editing Charts
    • Inserting Images
    • Using Shapes
    • Working with Icons
    • 3D Models
    • Working with SmartArt
    • Using Building Blocks

    Lesson 6: Viewing Your Documents - Quizzes: 1, Assignments: 2

    • Document Views
    • Using the Navigation Pane
    • Multiple Windows
    • Object Zoom Feature

    Intermediate Microsoft Word Exam

    Part 6 - Advanced Microsoft Word Training

    Lesson 1: Working with Long Documents - Quizzes: 1, Assignments: 4

    • Adding a Table of Contents
    • Updating the Table of Contents
    • Deleting the Table of Contents
    • Cross References
    • Footnotes and Endnotes
    • Inserting Citations and a Bibliography
    • Adding an Index
    • Inserting a Table of Figures
    • Inserting and Updating a Table of Authorities
    • Using Bookmarks
    • Go To Feature

    Lesson 2: Reviewing and Collaborating on Documents - Quizzes: 1, Assignments: 4

    • Adding Comments
    • Tracking Changes
    • Viewing Changes
    • Accepting and Rejecting Changes
    • Sharing

    Lesson 3: Comparing and Combining Documents - Quizzes: 1, Assignments: 2

    • Comparing Documents
    • Combining Documents

    Lesson 4: Forms - Quizzes: 1, Assignments: 6

    • Showing the Developer Tab

    Lesson 5: Managing Mailings - Quizzes: 1, Assignments: 2

    • Creating Envelopes and Labels
    • Using Mail Merge

    Lesson 6: Protecting Documents - Quizzes: 1, Assignments: 2

    • Marking Documents Final
    • Password Protect Word Documents
    • Removing Metadata from Files
    • Restrict Formatting and Editing
    • Adding Watermarks

    Lesson 7: Macros - Quizzes: 0, Assignments: 1

    • Using Macros

    Advanced Microsoft Word Exam, Final Microsoft Word Exam

    Part 7 - Introduction to Microsoft PowerPoint Training

    Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

    • Logging in to Microsoft 365
    • Installing Applications
    • Creating New Files and AutoSaving
    • Protected View
    • File Sharing
    • File Collaboration
    • Version History
    • Getting Updates
    • Mac Versions

    Lesson 2: Creating a Presentation - Quizzes: 1, Assignments: 1

    • Starting Microsoft PowerPoint
    • Creating a Presentation
    • Saving a Presentation
    • The Status Bar
    • Closing a Presentation

    Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

    • Tabs
    • Groups and Commands
    • Microsoft Search Box
    • Customizing the Ribbon

    Lesson 4: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

    • Getting Started
    • Adding Common Commands
    • Adding More Commands with the Customize Dialog Box
    • Adding Ribbon Commands or Groups

    Lesson 5: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 2

    • Introduction to the Backstage View
    • Opening a Presentation
    • New Presentations and Presentation Templates
    • Adding Your Name to Microsoft PowerPoint

    Lesson 6: Formatting Presentations - Quizzes: 1, Assignments: 1

    • Selecting a Slide Layout
    • Adding and Editing Text
    • Adding Text from a Text File or Word Outline
    • Formatting Text
    • Text Effects and WordArt
    • Bulleted and Numbered Lists
    • Columns
    • Adding Slides to a Presentation
    • Arranging Slides

    Lesson 7: Working with Images - Quizzes: 1, Assignments: 1

    • Adding Images to a Slide
    • Removing an Image Background
    • Picture Format Tools Tab
    • Grouping and Ungrouping Images
    • Arranging Images
    • Adding Shapes
    • Working with Icons
    • 3D Models
    • Using Digital Ink

    Lesson 8: Working with Tables and Charts - Quizzes: 1, Assignments: 2

    • Inserting a Table
    • Formatting Tables
    • Importing Tables from External Sources
    • Inserting a Chart
    • Formatting a Chart
    • Importing Charts from External Sources

    Lesson 9: Preparing and Presenting - Quizzes: 1, Assignments: 2

    • Checking Spelling
    • Accessing Different Views of a Presentation
    • Running the Slide Show
    • Organizing a Presentation in Sections
    • Adding Transitions to Slides
    • Adding Speaker Notes
    • Printing a Presentation

    Lesson 10: Using Copilot in Microsoft PowerPoint - Quizzes: 1, Assignments: 1

    • Copilot in Microsoft 365 PowerPoint
    • Creating a New Presentation
    • Creating New Slides
    • Summarizing Large Amounts of Content
    • Branding a Deck

    Introduction to Microsoft PowerPoint Exam

    Part 8 - Advanced Microsoft PowerPoint Training

    Lesson 1: Customizing Presentations - Quizzes: 1, Assignments: 1

    • Applying a Theme
    • Formatting Backgrounds
    • Headers and Footers
    • Adding a Background Image

    Lesson 2: Presentation Masters - Quizzes: 1, Assignments: 1

    • Working with the Slide Master
    • Slide Layouts
    • Formatting Slide Masters and Layouts
    • Adding a Watermark to Your Presentation
    • Adding Slide Numbers Using the Slide Master
    • Inserting a New Slide Master
    • Removing Unused Slide Masters and Layouts
    • Modifying the Notes Master
    • Modifying the Handout Master

    Lesson 3: Working with Special Effects - Quizzes: 1, Assignments: 1

    • Animating Bullets
    • Working with the Animation Painter
    • Motion Paths
    • Animating a Chart
    • Slide Transitions

    Lesson 4: Using SmartArt - Quizzes: 1, Assignments: 1

    • Inserting SmartArt Graphics
    • Modifying SmartArt Graphics
    • Resizing/Repositioning a SmartArt Object
    • Inserting Text into a SmartArt Object
    • Adding Shapes to a SmartArt Object
    • Ungrouping SmartArt Objects

    Lesson 5: Multimedia - Quizzes: 1, Assignments: 2

    • Creating a Photo Album
    • Editing a Photo Album
    • Inserting Sounds and Video
    • Editing Media Clips

    Lesson 6: Setting up the Slide Show - Quizzes: 1, Assignments: 2

    • Setting up a Custom Slide Show
    • Creating a Hyperlink
    • Adding an Action Button
    • Zoom
    • Using Rehearse Timings
    • Navigating within a Slide Show
    • Annotating a Presentation
    • Recording a Slide Show

    Lesson 7: Outlines and Slides - Quizzes: 1, Assignments: 1

    • Exporting Handouts to Word
    • Exporting an Outline to Word
    • Saving a Presentation as an Outline
    • Saving a Slide as a Graphic

    Lesson 8: Managing Multiple Presentations - Quizzes: 1, Assignments: 1

    • Merging Multiple Presentations
    • Viewing Multiple Presentations
    • Tracking Changes in PowerPoint
    • Adding Comments

    Lesson 9: Finalizing Presentations - Quizzes: 1, Assignments: 0

    • Inspecting a Presentation
    • Encrypting a Presentation
    • Embedding the Fonts in a Presentation
    • Saving a Presentation in PDF Format
    • Compressing Pictures
    • Marking a Presentation as Final

    Advanced Microsoft PowerPoint Exam, Final Microsoft PowerPoint Exam

    Part 9 - Introduction to Microsoft Outlook 365 Training

    Lesson 1: The Outlook Interface - Quizzes: 1, Assignments: 0

    • Overview of the Outlook Interface
    • The Ribbon
    • Review of Differences Between Classic and New Layouts

    Lesson 2: Working with Messages - Quizzes: 1, Assignments: 1

    • Compose a Message
    • Add an Attachment
    • Add Polling Options
    • Check Spelling and Grammar
    • Format Text
    • Insert a Hyperlink or Image in a Message
    • Send a Message

    Lesson 3: Working with the Calendar - Quizzes: 1, Assignments: 2

    • Change Your Calendar View
    • Set Up Availability Status
    • Print Your Schedule
    • Share Your Calendar
    • Schedule a Meeting
    • Make Updates to Meetings
    • Cancel a Meeting
    • View Others’ Calendars
    • Delete a Calendar
    • Work with Calendar Items
    • Create and Add Calendars

    Lesson 4: Organizing Contacts - Quizzes: 1, Assignments: 1

    • Add, Delete, and Import/Export a Contact
    • Update a Contact
    • Locate a Contact
    • Sort Contacts
    • Work with Contact Lists
    • Manage Multiple Address Books

    Lesson 5: Working with Groups - Quizzes: 1, Assignments: 1

    • Search for a Group
    • Create a Group
    • Add or Remove Members
    • Send Email to a Group

    Lesson 6: Using Copilot in Microsoft Outlook

    • Copilot in Microsoft 365 Outlook
    • Emails
    • Meetings

    Introduction to Microsoft Outlook 365 Exam

    Part 10 - Advanced Microsoft Outlook 365 Training

    Lesson 1: Performing Popular Tasks - Quizzes: 1, Assignments: 3

    • Open Email Messages
    • Reply to and Forward Email Messages
    • Preview and Save an Attachment
    • Print a Message
    • Delete a Message
    • Save a Message in an Alternate Format
    • Customize the Navigation Pane

    Lesson 2: Working with Tasks and Notes - Quizzes: 1, Assignments: 1

    • Create a Task
    • Print a Task
    • Add Steps to a Task
    • Update a Task
    • Search for Tasks
    • Change Your Task View

    Lesson 3: Using Signature and Themes - Quizzes: 1, Assignments: 1

    • Create a Signature
    • Automatically Add a Signature to Messages
    • Modify a Signature
    • Format Outgoing Messages

    Lesson 4: Managing Your Inbox - Quizzes: 1, Assignments: 2

    • Search for Messages
    • Sort Messages
    • Add New Local Folders
    • Move Messages between Folders
    • Group Your Mailbox Items
    • Filter Messages
    • Organize Messages
    • Create and Manage Rules
    • Manage Your Junk Email
    • Archive Your Messages
    • Create a Quick Step
    • Create Auto-Replies

    Lesson 5: Working with Multiple Email Accounts - Quizzes: 1, Assignments: 1

    • Setting Up Multiple Accounts in Outlook
    • Send Emails from Different Accounts
    • POP vs. IMAP Email Protocols

    Advanced Microsoft Outlook 365 Exam, Microsoft Outlook 365 Final Exam

Requirements

Prerequisites

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO

Instructor

FAQs

Reviews

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO