Microsoft Office Specialist Bootcamp
MOS Exam Preparation Review

  • Duration: 5 days
  • Price: $875.00
  • Certifications:
  • Exams:

Microsoft Office courses are taught using Microsoft Office 2016. The interfaces and functions are completely compatible with Office 2010 and 2013.

Pricing Optionsadd_circle_outline

The Microsoft Office Bootcamp is priced on a decreasing cost-per-class scale. Students may register for any number of days during the bootcamp and come to class on the days that the course(s) for which they registered are taught.

Pricing for the MOS Bootcamp is as follows:

  • 1 course: $225.00
  • 2 courses: $425.00 (save $25)
  • 3 courses: $600.00 (save $75)
  • 4 courses: $750.00 (save $150)
  • 5 courses: $875.00 (save $250)

The more you take, the more you save!

Course Overviewadd_circle_outline

The Microsoft Office Specialist (MOS) certification is your pass into a career in office administration, from entry-level to administrative assistant to executive secretary for the CEO. At DWWTC, we prepared this course specifically to provide a focus on the objectives in which you will be expected to demonstrate competency on your exams. When you complete your certification you are showing prospective bosses and clients that you have the skills that they need!

Target Studentadd_circle_outline

This program of Microsoft Office classes is designed for people who are preparing for their Microsoft Office Specialist certification exam. Others who may benefit from this training include Administrative Assistants and others involved in administrative work who want to refresh their skills to move up the corporate ladder.

This is a great option for people preparing to recertify in Microsoft Office or to certify in a component for which they had not previously tested.


After completion of this bootcamp, the successful student will be able to take the requisite MOS exam(s) and--with preparation prior to the bootcamp and the exam(s)--successfully address all the Microsoft Office objective areas. Passing grade for the exam is 700 out of 1000 points.

Course Outlineadd_circle_outline

DAY ONE: Microsoft Word

  • Session 1: Creating and Managing Documents
    • Creating documents
    • Navigating through documents
    • Formatting documents
    • Customizing options and views for documents
    • Printing and saving documents
  • Session 2: Formatting Text, Paragraphs, and Sections
    • Inserting text and paragraphs
    • Formatting text and paragraphs
    • Ordering and grouping text and paragraphs
  • Session 3: Creating Tables and Lists
    • Creating a table
    • Modifying a table
    • Creating and modifying a list
  • Session 4: Creating and Managing References
    • Creating and managing reference markers
    • Creating and managing simple references
  • Session 5: Inserting and Formatting Graphic Elements
    • Inserting graphic elements
    • Formatting graphic elements
    • Inserting and formatting SmartArt graphics

DAY TWO: Microsoft Outlook

  • Session 1: Managing the Outlook Environment for Productivity
    • Customizing settings
    • Printing and saving information
    • Performing search operations
  • Session 2: Managing Messages
    • Configuring mail settings
    • Creating messages
    • Formatting a message
    • Organizing and managing messages
  • Session 3: Managing Schedules
    • Create and manage calendars
    • Create appointments, meetings, and events
    • Organize and manage appointments, meetings, and events
    • Create and manage notes and tasks
  • Session 4: Managing Contacts and Groups
    • Create and manage contacts
    • Create and manage contact groups

DAY THREE: Microsoft PowerPoint

  • Session 1: Creating and Managing Presentations
    • Creating a presentation
    • Inserting and formatting slides
    • Modifying slides, handouts, and notes
    • Ordering and grouping slides
    • Changing presentation options and views
    • Configuring a presentation to print
    • Configuring and presenting a slide show
  • Session 2: Inserting and Formatting Text, Shapes, and Images
    • Inserting and formatting text
    • Inserting and formatting shapes and text boxes
    • Inserting and formatting images
    • Ordering and grouping objects
  • Session 3: Inserting Tables, Charts, SmartArt, and Media
    • Inserting and formatting tables
    • Inserting and formatting charts
    • Inserting and formatting SmartArt graphics
    • Inserting and managing media
  • Session 4: Applying Transitions and Animations
    • Applying slide transitions
    • Animating slide content
    • Setting timing for transitions and animations
  • Session 5: Managing Multiple Presentations
    • Merging content from multiple presentations
    • Finalizing presentations

DAY FOUR: Microsoft Excel

  • Session 1: Creating and Managing Worksheets and Workbooks
    • Creating worksheets and workbooks
    • Navigating in worksheets and workbooks
    • Formatting worksheets and workbooks
    • Customizing options and views for worksheets and workbooks
    • Configuring worksheets and workbooks for distribution
  • Session 2: Managing Data Cells and Ranges
    • Inserting data in cells and ranges
    • Formatting cells and ranges
    • Summarizing and organizing data
  • Session 3: Creating Tables
    • Creating and managing tables
    • Managing table styles and options
    • Filtering and sorting a table
  • Session 4: Performing Operations with Formulas and Functions
    • Summarizing data by using functions
    • Performing conditional operations by using functions
    • Formatting and modifying text by using functions
  • Session 5: Creating Charts and Objects
    • Creating charts
    • Formatting charts
    • Inserting and formatting objects

DAY FIVE: Microsoft Access

  • Session 1: Creating and Managing a Database
    • Creating and modifying databases
    • Managing relationships and keys
    • Navigating through a database
    • Protecting and maintaining databases
    • Printing and exporting data
  • Session 2: Building Tables
    • Creating tables
    • Managing tables
    • Managing records in tables
    • Creating and modifying fields
  • Session 3: Creating Queries
    • Creating a query
    • Modifying a query
    • Creating calculated field and grouping within queries
  • Session 4: Creating Forms
    • Creating a form
    • Configure form controls
    • Formatting a form
  • Session 5: Creating Reports
    • Creating a report
    • Configuring report controls
    • Formatting a report

Students should have completed the following courses for their respective certification exam subject(s) prior to taking the Microsoft Office Specialist Bootcamp:

  • Microsoft Word 1/2/3
  • Microsoft Outlook 1/2
  • Microsoft PowerPoint 1/2
  • Microsoft Excel 1/2/3
  • Microsoft Access 1/2/3

Students who have not completed the courses, but are claiming an equivalent level of experience-based expertise, must indicate the level(s) by documenting their experience with the areas presented in the course outline.

Upcoming Classes
  • Click below to see more class dates with course versions
  • See More Dates
Have questions? Let us help you.