Microsoft Office Specialist (MOS) 2019 & 365 Course Bundle
This course bundle allows the freedom to study any of the Microsoft Office software packages and aim for either the Associate or Expert exams. Students will also have access to the course materials for a two-year period to allow additional time to complete your studies.
Microsoft offer single Certification for each Office 2019/365 exam passed, but they also offer Associate Certification if you pass three of the four available Associate level exams. Microsoft Office Specialist Expert Certification is gained if you gain the Associate Certification and then pass two of the three available Expert level exams.
Each individual course is designed to cover the appropriate MOS exam syllabus, and students will also receive official GMetrix Test Prep software for each of the courses.
uNITS
The MOS Excel 2019 & 365 Associate Course Includes the Following Units:
Unit 1: Managing Worksheets and Workbooks
The following topics are covered:
- Introduction;
- The Excel Application;
- Managing Worksheets & Workbooks;
- Navigating Worksheets & Workbooks;
- Formatting Worksheets & Workbooks;
- Customisation Option & Views;
- Configuring Content For Collaboration;
- Lesson Review & Quiz;
- Assignment 1 – Worksheet & Workbook Exercises.
Unit 2: Managing Data Cells and Ranges
The following topics are covered:
- Introduction;
- Manipulating Data in Worksheets;
- Formatting Cells & Ranges;
- Summarising Data Visually;
- Applying Formulas;
- Lesson Review & Quiz;
- Assignment 2 – Data Cell & Range Exercises.
Unit 3: Managing Tables and Table Data
The following topics are covered:
- Introduction;
- Creating & Formatting Tables;
- Modifying Tables;
- Filtering & Sorting Table Data;
- Introducing Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 – Table Exercises.
Unit 4: Perform Operations Using Functions
The following topics are covered:
- Introduction;
- Creating & Formatting Tables;
- Modifying Tables;
- Filtering & Sorting Table Data;
- Introducing Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 – Table Exercises.
Unit 5: Managing Charts and Objects
The following topics are covered:
- Introduction;
- Creating & Modifying Charts;
- Formatting Charts;
- Working With Objects;
- Lesson Review & Quiz;
- Assignment 5 – Charts & Object Exercises;
- The MOS Examination Explained.
The MOS Excel 2019 & 365 Expert Course Includes the Following Units:
Unit 1: Manage Workbook Options & Settings
The following topics are covered:
- Introduction;
- Managing Workbooks;
- Preparing Workbooks for Collaboration;
- Using and Configuring Language Options;
- Lesson Review & Quiz;
- Assignment 1 – Workbook Options & Settings Exercises.
Unit 2: Managing & Formatting Data
The following topics are covered:
- Introduction;
- Fill Cells Based on Existing Data;
- Formatting & Validating Data;
- Advanced Conditional Formatting & Filtering;
- Lesson Review & Quiz;
- Assignment 2 – Custom Data Formatting Exercises.
Unit 3: Creating Advanced Formulas & Macros
The following topics are covered:
- Introduction;
- Performing Logical Operations in Formulas;
- Lookup Data Using Functions;
- Using Advanced Date & Time Functions;
- Performing Data Analysis;
- Troubleshooting Formulas;
- Creating & Modifying Macros;
- Lesson Review & Quiz;
- Assignment 3 – Advanced Formula Exercises.
Unit 4: Managing Advanced Charts & Tables
The following topics are covered:
- Introduction;
- Creating & Modifying Advanced Charts;
- Creating & Modifying Pivot Tables;
- Managing Pivot Tables;
- Create & Modifying Pivot Charts;
- Lesson Review & Quiz;
- Assignment 4 – Advanced Table & Chart Exercises;
- The MOS Examination.
The MOS Word 2019 & 365 Associate Course Includes the Following Units:
Unit 1: Managing Documents
The following topics are covered:
- Introduction;
- Word Basics;
- Creating Documents;
- Navigating Within Documents;
- Formatting Documents;
- Saving, Customising, & Sharing Documents;
- Inspecting Documents For Issues;
- Lesson Review & Quiz;
- Assignment 1 – Word Document Exercises.
Unit 2: Inserting and Formatting Text and Paragraphs
The following topics are covered:
- Introduction;
- Inserting Text & Paragraphs;
- Formatting Text & Paragraphs;
- Creating & Configuring Document Sections;
- Lesson Review & Quiz;
- Assignment 2 – Formatting Exercises.
Unit 3: Managing Tables and Lists
The following topics are covered:
- Introduction;
- Creating a Table;
- Modifying A Table;
- Creating & Modifying Lists;
- Lesson Review & Quiz;
- Assignment 3 – Table & List Exercises.
Unit 4: Creating and Managing References
The following topics are covered:
- Introduction;
- Creating & Managing Reference Elements;
- Making Citations;
- Creating Captions;
- Creating & Managing Reference Tables;
- Lesson Review & Quiz;
- Assignment 4 – Reference Exercises.
Unit 5: Inserting and Formatting Graphic Elements
The following topics are covered:
- Introduction;
- Inserting Illustrations & Text Boxes;
- Formatting Illustrations & Text Boxes;
- Adding Text to Graphic Elements;
- Modifying Graphical Elements;
- Lesson Review & Quiz;
- Assignment 5 – Course Project;
- The MOS Examination Explained.
Unit 6: Managing Document Collaboration
The following topics are covered:
- Introduction;
- Adding & Managing Comments;
- Manging Change Tracking
The MOS Word 2019 & 365 Expert Course Includes the Following Units:
Unit 1: Managing Document Options & Settings
The following topics are covered:
- Introduction;
- Managing Documents & Templates;
- Preparing Documents for Collaboration;
- Managing Document Changes;
- Using & Configuring Language Options;
- Lesson Review & Quiz;
- Assignment 1 – Document Options & Settings Exercises.
Unit 2: Using Advanced Editing & Formatting
The following topics are covered:
- Introduction;
- Advanced Editing & Formatting;
- Advanced Page Setup;
- Advanced Formatting;
- Creating Styles;
- Lesson Review & Quiz;
- Assignment 2 – Advanced Editing & Formatting Exercises.
Unit 3: Creating Custom Document Elements
The following topics are covered:
- Introduction;
- Creating & Modifying Building Blocks;
- Creating Custom Design Elements;
- Creating & Managing Indexes;
- Creating & Managing Tables of Figures;
- Lesson Review & Quiz;
- Assignment 3 – Advanced Document Element Exercises.
Unit 4: Using Advanced Word Features
The following topics are covered:
- Introduction;
- Managing Forms, Fields, & Controls;
- Creating & Modifying Macros;
- Mail Merge Recipient Lists;
- Mail Merge Operations
- Lesson Review & Quiz;
- Assignment 4 – Advanced Word Feature Exercises;
- The MOS Examination.
The MOS PowerPoint 2019 & 365 Associate Course Includes the Following Units:
Unit 1: Managing Presentations
The following topics are covered:
- Getting started;
- The PowerPoint application;
- Creating presentations;
- Inserting and formatting slides;
- Modifying slide masters, handouts, and notes;
- Changing presentation options and views;
- Configuring a presentation for printing;
- Configuring and presenting a slide show;
- Preparing presentations for collaboration;
- Lesson review & quiz;
- Assignment 1 – Creating an AGM presentation.
Unit 2: Managing Slides
The following topics are covered:
- Introduction;
- Inserting slides;
- Modifying slides;
- Ordering & grouping slides;
- Lesson review & quiz;
- Assignment 2 – Adding to the AGM presentation.
Unit 3: Inserting & Formatting Text, Shapes, & Images
The following topics are covered:
- Introduction;
- Formatting text;
- Inserting links;
- Inserting and formatting images;
- Inserting and formatting graphic elements;
- Ordering and grouping objects;
- Lesson review & quiz;
- Assignment 3 – Updating the AGM presentation with text boxes, shapes, & images.
Unit 4: Inserting Tables, Charts, SmartArt, 3D Models, & Media
The following topics are covered:
- Introduction;
- Inserting and formatting tables;
- Inserting and modifying charts;
- Inserting and formatting SmartArt graphics;
- Inserting and modifying 3D models;
- Inserting and managing media;
- Lesson review & quiz;
- Assignment 4 – Updating the AGM presentation with tables, charts, SmartArt, & media.
Unit 5: Applying Transitions & Animations
The following topics are covered:
- Introduction;
- Applying and configuring slide transitions;
- Animating slide content;
- Set timing for transitions and animations;
- Lesson review & quiz;
- Assignment 5 – Adding transitions and animations to the AGM presentation;
- The MOS Examination.
The MOS Outlook 2019 & 365 Associate Course Includes the Following Units:
Unit 1: Managing Settings & Processes
The following topics are covered:
- Getting started;
- Customising Outlook settings;
- Configuring mail settings;
- Performing search operations;
- Printing & saving information;
- Lesson review & quiz;
- Assignment 1 – Outlook settings and processes exercises.
Unit 2: Managing Messages
The following topics are covered:
- Introduction;
- Creating Messages;
- Message options;
- Inserting message content;
- Organising messages;
- Managing messages;
- Lesson review & quiz;
- Assignment 2 – Managing messages exercises.
Unit 3: Mail Settings & Formatting
The following topics are covered:
- Introduction;
- Configuring mail settings;
- Formatting messages;
- Managing conversations;
- Quick Steps, archiving, and delegating access;
- Lesson review & quiz;
- Assignment 3 – Mail settings and formatting exercises.
Unit 4: Managing Schedules
The following topics are covered:
- Introduction;
- Creating & managing calendars;
- Creating appointments, meetings, & events;
- Organising & managing appointments, meetings, & events;
- Lesson review & quiz;
- Assignment 4 – Scheduling exercises.
Unit 5: Managing Contacts & Tasks
The following topics are covered:
- Introduction;
- Creating & managing contacts;
- Managing address books;
- Creating & managing contact groups;
- Creating & managing notes & tasks;
- Lesson Review & Quiz;
- Assignment 5 – Contacts & tasks exercises;
- The MOS examination.
The MOS Access 2019 & 365 Expert Course Includes the Following Units:
Unit 1: Managing Databases
The following topics are covered:
- Introduction;
- Modifying Database Structure;
- Managing Table Relationships & Keys;
- Printing & Exporting Data;
- Lesson Review & Quiz;
- Assignment 1 – Creating & Modifying Databases Exercises.
Unit 2: Creating & Modifying Tables
The following topics are covered:
- Introduction;
- Creating Tables;
- Managing Tables;
- Managing Records In Tables;
- Creating & Modifying Fields;
- Lesson Review & Quiz;
- Assignment 2 – Database Table Exercises.
Unit 3: Creating & Modifying Queries
The following topics are covered:
- Introduction;
- Creating & Running Queries (1);
- Creating & Running Queries (2);
- Modifying Queries;
- Creating Calculated Fields & Grouping;
- Lesson Review & Quiz;
- Assignment 3 – Query Exercises.
Unit 4: Modifying Forms in Layout View
The following topics are covered:
- Introduction;
- Configuring Form Controls (1);
- Configuring Form Controls (2);
- Formatting Forms (1);
- Formatting Forms (2);
- Lesson Review & Quiz;
- Assignment 4 – Forms Exercises.
Unit 5: Modifying Reports in Layout View
The following topics are covered:
- Introduction;
- Configuring Report Controls;
- Formatting Reports;
- Lesson Review & Quiz;
- Assignment 5 – Report Exercises;
- The MOS Examination.
Key Information
Cost
Course Format
Self-study Time
Delivery Time
GMetrix Test Prep Software
The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.
Overview of Test features:
- Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
- All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
- All tests have both a testing and a training mode providing step-by-step help on each question.
- Progress at own pace, save test to resume later, return to skipped questions.
- Detailed, printable score report highlighting areas requiring further review.
Please Note: You will need a version of Microsoft Office to be able to use the GMetrix software package.
Prerequisites
There are no particular entry requirements as the course is set out for beginners, although students will require their own version of Microsoft Office 2019 or Microsoft Office 365 to complete the course.
Please Note: This course covers the PC versions of Microsoft Office. It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office and will differ slightly from the Mac versions.
Course Duration & Online Support
Students may register at any time and have two-years to complete their studies. You also have access to a personal tutor by mail or email for a two-year period. Course extensions can be purchased if you do not complete this course within the set period. As the course is self-study you can complete in as little or as long a time as you prefer.
Assessment
You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, and create and edit Microsoft office documents and files. Your work can be sent back to your course tutor by email.
MOS Office 2019/365 Certification
On Completion of each course, you will receive our own Certificate of Completion and students can also apply for the Microsoft MOS Examinations detailed below:
- MOS Excel 2019 & 365 Associate MO-200
- MOS Word 2019 & 365 Associate MO-100
- MOS PowerPoint 2019 & 365 Associate MO-300
- MOS Outlook 2019 & 365 Associate MO-400
- MOS Excel 2019 & 365 Expert MO-201
- MOS Word 2019 & 365 Expert MO-101
- MOS Access 2019 & 365 Expert MO-500
Examinations must be sat at a registered Certiport Testing Centre. You should choose the Program, Version and Exam before adding your location for a list of suitable exam centres.
Exam vouchers (Valid for 12 Months) can be purchased for £90.00. We usually advise buying a voucher when you are ready to sit your test, although you can add this to your order when you purchase your course.
Please Note: Exam Centres will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.
