• 0800 677 1232
  • info@robustittraining.com
  • Facebook:
  • LinkedIn:
  • Youtube:

Microsoft Office Specialist

Microsoft Office 2016

About

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program.

What is a Microsoft Office Specialist Qualification?

What is a MOS Qualification? Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each program serves a different purpose and is compatible with other programs included in the package. The suite of programs is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level - excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training program is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

NEW

Microsoft Office Certifications for Office 365 and Office 2019

Exams for Word Associate, Excel Associate, PowerPoint Associate certifications released first, and exams for Outlook Associate, Access Expert, Word Expert and Excel Expert certifications are coming soon. You will still earn a certification for each exam you pass. Also:

  • Starting in late July 2019, if you pass three Associate exams, you will be awarded the Microsoft Office Specialist: Associate certification.

  • Starting in mid-August 2019, if you earn a Microsoft Office Specialist Associate certification and pass two additional Expert exams, you will be awarded the Microsoft Office Specialist: Expert certification, the highest certification in the Microsoft Office Specialist program.

Benefits of training with us

  • Intuitive and rewarding online training resources

  • 24/7 access to our unique course materials

  • Custom built practical tasks and challenges
  • Official mock examinations to fully prepare you for any final exams
  • Career advice and CV support once training has been completed
  • Full printable course materials, allowing you take your learning offline at your own convenience

Enquiry Form

Request More Information

Exam MO-100
Microsoft Word (Word and Word 2019)
An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level, and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Word and can complete tasks independently.

Manage documents (20-25%)
Navigate within documents
  • Search for text
  • Link to locations within documents
  • Move to specific locations and objects in documents
  • Show and hide formatting symbols and hidden text
Format documents
  • Set up document pages
  • Apply style sets
  • Insert and modify headers and footers
  • Configure page background elements
Save and share documents
  • Save documents in alternative file formats
  • Modify basic document properties
  • Modify print settings
  • Share documents electronically
Inspect documents for issues
  • Locate and remove hidden properties and personal information
  • Locate and correct accessibility issues
  • Locate and correct compatibility issues
Insert and format text, paragraphs, and sections (20-25%)
Insert text and paragraphs
  • Find and replace text
  • Insert symbols and special characters
Format text and paragraphs
  • Apply text effects
  • Apply formatting by using Format Painter
  • Set line and paragraph spacing and indentation
  • Apply built-in styles to text
  • Clear formatting
Create and configure document sections
  • Format text in multiple columns
  • Insert page, section, and column breaks
  • Change page setup options for a section
Manage tables and lists (15-20%)
Create tables
  • Convert text to tables
  • Convert tables to text
  • Create tables by specifying rows and columns
Modify tables
  • Sort table data
  • Configure cell margins and spacing
  • Merge and split cells
  • Resize tables, rows, and columns
  • Split tables
  • Configure a repeating row header
Create and modify lists
  • Format paragraphs as numbered and bulleted lists
  • Change bullet characters and number formats
  • Define custom bullet characters and number formats
  • Increase and decrease list levels
  • Restart and continue list numbering
  • Set starting number values
Create and manage references (5-10%)
Create and manage reference elements
  • Insert footnotes and endnotes
  • Modify footnote and endnote properties
  • Create and modify bibliography citation sources
  • Insert citations for bibliographies
Create and manage reference tables
  • Insert tables of contents
  • Customize tables of contents
  • Insert bibliographies
Insert and format graphic elements (15-20%)
Insert illustrations and text boxes
  • Insert shapes
  • Insert pictures
  • Insert 3D models
  • Insert SmartArt graphics
  • Insert screenshots and screen clippings
  • Insert text boxes
Format illustrations and text boxes
  • Apply artistic effects
  • Apply picture effects and picture styles
  • Remove picture backgrounds
  • Format graphic elements
  • Format SmartArt graphics
  • Format 3D models
Add text to graphic elements
  • Add and modify text in text boxes
  • Add and modify text in shapes
  • Add and modify SmartArt graphic content
Modify graphic elements
  • Position objects
  • Wrap text around objects
  • Add alternative text to objects for accessibility
Manage document collaboration (5-10%)
Add and manage comments
  • Add comments
  • Review and reply to comments
  • Resolve comments
  • Delete comments
Manage change tracking
  • Track changes
  • Review tracked changes
  • Accept and reject tracked changes
  • Lock and unlock change tracking
Exam MO-200
Microsoft Excel (Excel and Excel 2019)
An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.

Manage worksheets and workbooks (10-15%)
Import data into workbooks
  • Import data from .txt files
  • Import data from .csv files
Navigate within workbooks
  • Search for data within a workbook
  • Navigate to named cells, ranges, or workbook elements
  • Insert and remove hyperlinks
Format worksheets and workbooks
  • Modify page setup
  • Adjust row height and column width
  • Customize headers and footers
Customize options and views
  • Customize the Quick Access toolbar
  • Display and modify workbook content in different views
  • Freeze worksheet rows and columns
  • Change window views
  • Modify basic workbook properties
  • Display formulas
Configure content for collaboration
  • Set a print area
  • Save workbooks in alternative file formats
  • Configure print settings
  • Inspect workbooks for issues
Manage data cells and ranges (20-25%)
Manipulate data in worksheets
  • Paste data by using special paste options
  • Fill cells by using Auto Fill
  • Insert and delete multiple columns or rows
  • Insert and delete cells
Format cells and ranges
  • Merge and unmerge cells
  • Modify cell alignment, orientation, and indentation
  • Format cells by using Format Painter
  • Wrap text within cells
  • Apply number formats
  • Apply cell formats from the Format Cells dialog box
  • Apply cell styles
  • Clear cell formatting
Define and reference named ranges
  • Define a named range
  • Name a table
Summarize data visually
  • Insert Sparklines
  • Apply built-in conditional formatting
  • Remove conditional formatting
Manage tables and table data (15-20%)
Create and format tables
  • Create Excel tables from cell ranges
  • Apply table styles
  • Convert tables to cell ranges
Modify tables
  • Add or remove table rows and columns
  • Configure table style options
  • Insert and configure total rows
Filter and sort table data
  • Filter records
  • Sort data by multiple columns
Perform operations by using formulas and functions (20-25%)
Insert references
  • Insert relative, absolute, and mixed references
  • Reference named ranges and named tables in formulas
Calculate and transform datas
  • Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
  • Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
  • Perform conditional operations by using the IF() function
Format and modify text
  • Format text by using RIGHT(), LEFT(), and MID() functions
  • Format text by using UPPER(), LOWER(), and LEN() functions
  • Format text by using the CONCAT() and TEXTJOIN() functions
Manage charts (20-25%)
Create charts
  • Create charts
  • Create chart sheets
Modify charts
  • Add data series to charts
  • Switch between rows and columns in source data
  • Add and modify chart elements
Format charts
  • Apply chart layouts
  • Apply chart styles
  • Add alternative text to charts for accessibility
Exam MO-300
Microsoft PowerPoint (PowerPoint and PowerPoint 2019)
An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principle features of PowerPoint and can complete tasks independently.

Manage presentations
Modify slide masters, handout masters, and note masters
  • change the slide master theme or background
  • modify slide master content
  • create slide layouts
  • modify slide layouts
  • modify the handout master
  • modify the notes master
Change presentation options and views
  • change slide size
  • display presentations in different views
  • set basic file properties
Configure print settings for presentations
  • print all or part of a presentation
  • print notes pages
  • print handouts
  • print in color, grayscale, or black and white
Configure and present slide shows
  • create custom slide shows
  • configure slide show options
  • rehearse slide show timing
  • set up slide show recording options
  • present slide shows by using Presenter View
Prepare presentations for collaboration
  • mark presentations as final
  • protect presentations by using passwords
  • inspect presentations for issues
  • add and manage comments
  • preserve presentation content
  • export presentations to other formats
Manage slides
Insert slides
  • import Word document outlines
  • insert slides from another presentation
  • insert slides and select slide layouts
  • insert Summary Zoom slides
  • duplicate slides
Modify slides
  • hide and unhide slides
  • modify individual slide backgrounds
  • insert slide headers, footers, and page numbers
Order and group slides
  • create sections
  • modify slide order
  • rename sections
Insert and format text, shapes, and images
Format text
  • apply formatting and styles to text
  • format text in multiple columns
  • create bulleted and numbered lists
Insert links
  • insert hyperlinks
  • insert Section Zoom links and Slide Zoom links
Insert and format images
  • resize and crop images
  • apply built-in styles and effects to images
  • insert screenshots and screen clippings
Insert and format graphic elements
  • insert and change shapes
  • draw by using digital ink
  • add text to shapes and text boxes
  • resize shapes and text boxes
  • format shapes and text boxes
  • apply built-in styles to shapes and text boxes
  • add alt text to graphic elements for accessibility
Order and group objects on slides
  • order shapes, images, and text boxes
  • align shapes, images, and text boxes
  • group shapes and images
  • display alignment tools
Insert tables, charts, smartArt, 3D models, and media
Insert and format tables
  • create and insert tables
  • insert and delete table rows and columns
  • apply built-in table styles
Insert and modify charts
  • create and insert charts
  • modify charts
Insert and format SmartArt graphics
  • insert SmartArt graphics
  • convert lists to SmartArt graphics
  • add and modify SmartArt graphic content
Insert and modify 3D models
  • insert 3D models
  • modify 3D models
Insert and manage media
  • insert audio and video clips
  • create and insert screen recordings
  • configure media playback options
Apply transitions and animations
Apply and configure slide transitions
  • apply basic and 3D slide transitions
  • configure transition effects
Animate slide content
  • animate text and graphic elements
  • animate 3D models
  • configure animation effects
  • configure animation paths
  • reorder animations on a slide
Set timing for transitions
  • set transition effect duration
  • configure transition start and finish options
Exam 77-725
Word 2016: Core Document Creation, Collaboration, and Communication
Successful candidates for the Word 2016 exam have a fundamental understanding of the Word environment and the ability to complete tasks independently. They demonstrate the correct application of the principle features of Word 2016 by creating and editing two- to three-page documents for a variety of purposes and situations. Document examples include professional-looking reports, multi-column newsletters, resumes, and business correspondence.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate's knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.
Exam 77-727
Excel 2016: Core Data Analysis, Manipulation, and Presentation
Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principle features of Excel 2016. Candidates create and edit a workbook with multiple sheets, and they use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate's knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.
Exam 77-729
Microsoft Office PowerPoint 2016
Successful candidates will have a fundamental understanding of the PowerPoint environment and demonstrate the correct application of PowerPoint 2016. Candidates create, edit, and enhance presentations and slide shows. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slide shows.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate's knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.
Exam 77-730
Microsoft Office Access 2016
Successful candidates for the Access 2016 exam have a fundamental understanding of the application's environment. They understand basic database design principles and are able to complete tasks independently. They know and demonstrate the correct application of the principle features of Access 2016, and they demonstrate the ability to create and maintain basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate's knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.
Exam 77-731
Microsoft Outlook 2016
Successful candidates will create and edit professional-looking email messages, maintain calendars across time zones, and schedule tasks for a variety of purposes and situations. Candidates will use Outlook 2016 to enhance professional correspondence, create calendars, and schedule appointments. Application examples include coordinating building resources, sending messages for marketing campaigns, planning staff meetings, and assigning meeting action items.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate's knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.
  • Official Microsoft Office Exams

  • Online or classroom training

  • Interactive mock exams

  • Live Lab (access to LIVE software)

  • Free Phone Support

  • Online & Email Support

  • World wide Recognised Qualification

  • Unlimited access for 12 months
  • Office Manager

  • Executive Assistant

  • Administrative Assistant

  • IT Support Technician

  • SharePoint Specialist

  • Database Specialist

  • Workbook Developer

  • + More

Courses you might also be interested in

Information Technology Qualification

We offer Superb quality training materials which are also used by international clients including many organizations and leading educational establishments. Used by freelance trainers, schools...

Find out more

Microsoft Office Specialist Expert


This certification demonstrates that you have advanced skills in key Office programs by earning a Microsoft Office Specialist Expert certification. What is a MOS Qualification? Microsoft Office is a...

Find out more

Microsoft Office Specialist Master


This certification demonstrates that you have the deepest level of skills needed to proficiently use Office programs by earning a Microsoft Office Specialist Master certification. What is a MOS Qualification...

Find out more

Our training is trusted and accredited
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1