Microsoft Office Specialist (MOS) 2016 Course Bundle

£ 581.25

The Microsoft Office Specialist MOS 2016 Course Bundle from Distance Learning Centre allows students to purchase all 7 of the Microsoft Office Specialist Courses for only £650.00. Studnets can aim for Core, Expert or Master Exams.

Gain the Microsoft Office 2016 Master Certification!

The Microsoft Office Specialist (MOS) 2016 Course Bundle allows students to purchase all seven of the Microsoft Office Specialist Online Courses for only £650.00.

Microsoft Office Specialist (MOS) certification is the leading IT certification in the world with more than 1 million MOS exams taken every year in over 140 countries. The Certification is designed for students to demonstrate they have the knowledge, skills, and abilities to productively use Microsoft Office software.

With this course bundle you will receive seven courses covering all Microsoft Office Specialist Certification for Microsoft Word, Excel, Access, PowerPoint and Outlook 2016. The course bundle covers all possible Core and Expert exams for Office 2016.

Students can also gain MOS 2016 Master Certification by completion the Word 2016 Expert, Excel 2016 Expert, PowerPoint 2016 Core and an elective exam choice of either Access 2016 Core or Outlook 2016 Core. You can also find information on the new Microsoft Office 2019 & 365 Courses from the MOS course overview page.

Online Course Format

Based on the proven “learn-by-example” principle which, as the name implies, provides real-world examples to illustrate a particular topic or technique, the courses are delivered through the Distance Learning Centre’s highly-acclaimed on-line training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari. You will also be supported by a personal tutor who is available to provide feedback on your work at any time throughout the period of study.

The MOS Excel 2016 Essentials Course Includes the Following Units:
The following topics are covered: Introduction; The Excel 2016 Application; Managing Worksheets & Workbooks; Navigating Worksheets & Workbooks; Formatting Worksheets & Workbooks; Customisation Options; Configuration Options; Lesson Review & Quiz; and Assignment 1 – Worksheet & Workbook Exercises.
The following topics are covered: Introduction; Inserting Data; Formatting Data; Ordering & Grouping; Applying Formulas; Lesson Review & Quiz; and Assignment 2 – Cell & Range Exercises.
The following topics are covered: Introduction; Creating Tables; Modifying A Table; Filter & Sort A Table; Pivot Tables & Charts; Lesson Review & Quiz; and Assignment 3 – Table Exercises.
The following topics are covered: Introduction; Summarise Data With Functions; Use Conditional Logic In Functions; Format & Modify Text With Functions; Useful Maths Functions; Date & Time Functions; Lesson Review & Quiz; and Assignment 4 – Function Exercises.
The following topics are covered: Introduction; Creating A Chart; Formatting A Chart; Working With Objects; Lesson Review & Quiz; Assignment 5 – Charts & Object Exercises; and The MOS Examination Explained.

The MOS Excel 2016 Expert Course Includes the Following Units:
The following topics are covered: Introduction; Managing Workbooks; Restrict Editing & Protect Workbooks; Version Control & Formula Options; Lesson Review & Quiz; and Assignment 1 – Workbook Options & Settings Exercises.
The following topics are covered: Introduction; Applying Custom Data Formats & Validation; Advanced Conditional Formatting & Filtering; Creating & Modifying Custom Workbook Elements; Preparing A Workbook For Internationalisation; Lesson Review & Quiz; and Assignment 2 – Custom Data Formatting Exercises.
The following topics are covered: Introduction; Applying Functions in Formulas; Lookup Data Using Functions; Applying Advanced Date & Time Functions; Importing & Analysing External Data; Business Intelligence Features; Troubleshooting Formulas; Defining Named Ranges & Objects; Lesson Review & Quiz; and Assignment 3 – Advanced Formula Exercises.
The following topics are covered: Introduction; Creating Advanced Charts; Creating Pivot Tables; Managing Pivot Tables; Create & Managing Pivot Charts; Lesson Review & Quiz; Assignment 4 – Advanced Table & Chart Exercises; and The MOS Examination.

The MOS Word 2016 Essentials Course Includes the Following Units:
The following topics are covered: Introduction; Word Basics; Creating Documents; Navigating Documents; Formatting Documents; Customisation Document Options & Views; Printing & Saving Documents; Lesson Review & Quiz; and Assignment 1 – Word Document Exercises.
The following topics are covered: Introduction; Inserting Text & Paragraphs; Formatting Text & Paragraphs; Ordering & Grouping Text & Paragraphs; Lesson Review & Quiz; and Assignment 2 – Formatting Exercises.
The following topics are covered: Introduction; Creating a Table; Modifying A Table; Creating & Modifying Lists; Lesson Review & Quiz; Assignment 3 – Table & List Exercises.
The following topics are covered: Introduction; Creating Endnotes & Footnotes; Making Citations; Inserting Figure & Table Captions; Create & Manage Simple References; Lesson Review & Quiz; and Assignment 4 – Reference Exercises.
The following topics are covered: Introduction; Inserting Graphic Elements; Format Graphic Elements; Inserting & Formatting SmartArt Graphics; Lesson Review & Quiz; Assignment 5 – Course Project; and The MOS Examination Explained.

The MOS Word 2016 Expert Course Includes the Following Units:
The following topics are covered: Introduction; Managing Documents & Templates; Preparing Documents for Review; Managing Document Changes; Lesson Review & Quiz; and Assignment 1 – Document Options & Settings Exercises.
The following topics are covered: Introduction; Advanced Editing & Formatting; Advanced Page Setup; Advanced Formatting; Creating Styles; Lesson Review & Quiz; and Assignment 2 – Advanced Document Exercises.
The following topics are covered: Introduction; Creating & Managing Indexes; Creating & Managing Reference Tables; Managing Fields; Mail-Merge Operations (1); Mail-Merge Operations (2); Lesson Review & Quiz; and Assignment 3 – Advanced References Exercises.
The following topics are covered: Introduction; Creating & Modifying Building Blocks & Macros; Creating & Modifying Content Controls; Creating Custom Style Sets & Templates; Preparing a Document for Internationalisation & Accessibility; Lesson Review & Quiz; Assignment 4 – Custom Element Exercises; and The MOS Examination.

The MOS PowerPoint 2016 Essentials Course Includes the Following Units:
The following topics are covered: Introduction; Creating presentations; Inserting and formatting slides; Modifying slides, handouts, and notes; Ordering and grouping slides; Changing presentation options and views; Configuring a presentation for printing; Configuring and presenting a slide show; Lesson Review & Quiz; and Assignment 1 – Create an AGM Presentation.
The following topics are covered: Introduction; Inserting and formatting text; Using WordArt; Lists & Hyperlinks; Insert and format shapes and text boxes; Insert and format images; Order and group objects; Lesson Review & Quiz; and Assignment 2 – Update AGM Presentation.
The following topics are covered: Introduction; Insert and format tables; Insert and format charts; Insert and format SmartArt graphics; Insert and manage media; Lesson Review & Quiz; and Assignment 3 – Update AGM Presentation.
The following topics are covered: Introduction; Apply slide transitions; Animate slide content; Set timing for transitions and animations; Lesson Review & Quiz; and Assignment 4 – Update AGM Presentation.
The following topics are covered: Introduction; Merging Content; Protecting & Checking; Proofing & Packaging; Lesson Review & Quiz; Assignment 5 – Finalising A Presentation; and The MOS Examination.

The MOS Outlook 2016 Essentials Course Includes the Following Units:
The following topics are covered: Introduction; Customise Settings; Printing & Saving Information; Performing Search Operations; Lesson Review & Quiz; and Assignment 1 – Outlook Environment Exercises.
The following topics are covered: Introduction; Configuring Mail Settings; Creating Messages; Formatting Messages; Organising Messages; Managing Messages; Lesson Review & Quiz; and Assignment 2 – Managing Messages Exercises.
The following topics are covered: Introduction; Creating & Managing Calendars; Creating Appointments, Meetings, & Events; Organising & Managing Appointments, Meetings, & Events; Creating & Managing Notes & Tasks; Lesson Review & Quiz; and Assignment 3 – Managing Schedule Exercises.
The following topics are covered: Introduction; Creating & Managing Contacts; Managing Address Books; Creating & Managing Contact Groups Lesson Review & Quiz; Assignment 4 – Managing Contacts & Groups Exercises; and The MOS Examination.

The MOS Access 2016 Essentials Course Includes the Following Units:
The following topics are covered: Introduction; The Access 2016 Application; Creating & Modifying Databases; Managing Relationships & Keys; Navigating Through A Database; Protecting & Maintaining Databases; Printing & Exporting Data; Lesson Review & Quiz; and Assignment 1 – Creating & Modifying Databases Exercises.
The following topics are covered: Introduction; Creating Tables; Managing Tables; Managing Records In Tables; Creating & Modifying Fields; Lesson Review & Quiz; and Assignment 2 – Database Table Exercises.
The following topics are covered: Introduction; Creating Tables; Managing Tables; Managing Records In Tables; Creating & Modifying Fields; Lesson Review & Quiz; and Assignment 2 – Database Table Exercises.
The following topics are covered: Introduction; Creating Forms; Configuring Form Controls (1); Configuring Form Controls (2); Formatting Forms; Lesson Review & Quiz; and Assignment 4 – Forms Exercises.
The following topics are covered: Introduction; Creating Reports; Configuring Report Controls; Formatting Reports; Lesson Review & Quiz; Assignment 5 – Report Exercises; and The MOS Examination.

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. 

MOS Exam Voucher (Optional) – £90.00

All students have the option to purchase MOS Exam Vouchers for £90.00 which will cover the cost of the exam at participating exam centres. A voucher would be required for each MOS exam you sit. An additional proctoring fee will need to be paid to the exam centre for each exam.

Please Note: It is the students responsibility to source suitable exam centres. We advise researching exam centres prior to purchasing an exam voucher to make sure a suitable participating exam centre is available. 

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 2016 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.

Microsoft Office Specialist 2016 Examinations

MOS 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 2016 Core 77-727
  • MOS Word 2016 Core 77-725
  • MOS PowerPoint 2016 77-729
  • MOS Access 2016 Core 77-730
  • MOS Outlook 2016 77-731
  • MOS Excel 2016 Expert 77-728
  • MOS Word 2016 Expert 77-726

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 from our website 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.

Additional information

Course Format

Online Course

Self-Study Time

Approximately 500 Hours (Self-Study)

Delivery Time

1-2 Working Days (Email)