Microsoft Office Specialist (MOS) 2016 Course Bundle
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.
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.
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.
uNITS
The MOS Excel 2016 Essentials Course Includes the Following Units:
Unit 1: Worksheets & Workbooks
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;
- Assignment 1 – Worksheet & Workbook Exercises.
Unit 2: Managing Cells & Ranges
The following topics are covered:
- Introduction;
- Inserting Data;
- Formatting Data;
- Ordering & Grouping;
- Applying Formulas;
- Lesson Review & Quiz;
- Assignment 2 – Cell & Range Exercises.
Unit 3: Managing Tables
The following topics are covered:
- Introduction;
- Creating Tables;
- Modifying A Table;
- Filter & Sort A Table;
- Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 – Table Exercises.
Unit 4: Excel Functions
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;
- Assignment 4 – Function Exercises.
Unit 5: Inserting Charts & Objects
The following topics are covered:
- Introduction;
- Creating A Chart;
- Formatting A Chart;
- Working With Objects;
- Lesson Review & Quiz;
- Assignment 5 – Charts & Object Exercises;
- The MOS Examination Explained.
The MOS Excel 2016 Expert Course Includes the Following Units:
Unit 1: Manage Workbook Options & Settings
The following topics are covered:
- Introduction;
- Managing Workbooks;
- Restrict Editing & Protect Workbooks;
- Version Control & Formula Options;
- Lesson Review & Quiz;
- Assignment 1 – Workbook Options & Settings Exercises.
Unit 2: Apply Custom Data Formats & Layouts
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;
- Assignment 2 – Custom Data Formatting Exercises.
Unit 3: Creating Advanced Formulas
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;
- Assignment 3 – Advanced Formula Exercises.
Unit 4: Creating Advanced Charts & Tables
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;
- The MOS Examination.
The MOS Word 2016 Essentials Course Includes the Following Units:
Unit 1: Create & Manage Documents
The following topics are covered:
- Introduction;
- Word Basics;
- Creating Documents;
- Navigating Documents;
- Formatting Documents;
- Customisation Document Options & Views;
- Printing & Saving Documents;
- Lesson Review & Quiz;
- Assignment 1 – Word Document Exercises.
Unit 2: Formatting Text & Paragraphs
The following topics are covered:
- Introduction;
- Inserting Text & Paragraphs;
- Formatting Text & Paragraphs;
- Ordering & Grouping Text & Paragraphs;
- Lesson Review & Quiz;
- Assignment 2 – Formatting Exercises.
Unit 3: Creating Tables & 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: Applying References
The following topics are covered:
- Introduction;
- Creating Endnotes & Footnotes;
- Making Citations;
- Inserting Figure & Table Captions;
- Create & Manage Simple References;
- Lesson Review & Quiz;
- Assignment 4 – Reference Exercises.
Unit 5: Inserting & Formatting Graphic Elements
The following topics are covered:
- Introduction;
- Inserting Graphic Elements;
- Format Graphic Elements;
- Inserting & Formatting SmartArt Graphics;
- Lesson Review & Quiz;
- Assignment 5 – Course Project;
- The MOS Examination Explained.
The MOS Word 2016 Expert Course Includes the Following Units:
Unit 1: Managing Document Options & Settings
The following topics are covered:
- Introduction;
- Managing Documents & Templates;
- Preparing Documents for Review;
- Managing Document Changes;
- Lesson Review & Quiz;
- Assignment 1 – Document Options & Settings Exercises.
Unit 2: Designing Advanced Documents
The following topics are covered:
- Introduction;
- Advanced Editing & Formatting;
- Advanced Page Setup;
- Advanced Formatting;
- Creating Styles;
- Lesson Review & Quiz;
- Assignment 2 – Advanced Document Exercises.
Unit 3: Creating Advanced References
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;
- Assignment 3 – Advanced References Exercises.
Unit 4: Creating Custom Word Elements
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;
- The MOS Examination.
The MOS PowerPoint 2016 Essentials Course Includes the Following Units:
Unit 1: Creating & Managing Presentations
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;
- Assignment 1 – Create an AGM Presentation.
Unit 2: Inserting & Formatting Text, Shapes, & Images
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;
- Assignment 2 – Update AGM Presentation.
Unit 3: Inserting Tables, Charts, SmartArt, & Media
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;
- Assignment 3 – Update AGM Presentation.
Unit 4: Applying Transitions & Animations
The following topics are covered:
- Introduction;
- Apply slide transitions;
- Animate slide content;
- Set timing for transitions and animations;
- Lesson Review & Quiz;
- Assignment 4 – Update AGM Presentation.
Unit 5: Managing Multiple Presentations
The following topics are covered:
- Introduction;
- Merging Content;
- Protecting & Checking;
- Proofing & Packaging;
- Lesson Review & Quiz;
- Assignment 5 – Finalising A Presentation;
- The MOS Examination.
The MOS Outlook 2016 Essentials Course Includes the Following Units:
Unit 1: Managing the Outlook Environment
The following topics are covered:
- Introduction;
- Customise Settings;
- Printing & Saving Information;
- Performing Search Operations;
- Lesson Review & Quiz;
- Assignment 1 – Outlook Environment Exercises.
Unit 2: Managing Messages
The following topics are covered:
- Introduction;
- Configuring Mail Settings;
- Creating Messages;
- Formatting Messages;
- Organising Messages;
- Managing Messages;
- Lesson Review & Quiz;
- Assignment 2 – Managing Messages Exercises.
Unit 3: Managing Schedules
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;
- Assignment 3 – Managing Schedule Exercises.
Unit 4: Managing Contacts and Groups
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;
- The MOS Examination.
The MOS Access 2016 Essentials Course Includes the Following Units:
Unit 1: Creating and Managing Databases
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;
- Assignment 1 – Creating & Modifying Databases Exercises.
Unit 2: Building 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 Queries
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 4: Creating Forms
The following topics are covered:
- Introduction;
- Creating Forms;
- Configuring Form Controls (1);
- Configuring Form Controls (2);
- Formatting Forms;
- Lesson Review & Quiz;
- Assignment 4 – Forms Exercises.
Unit 5: Creating Reports
The following topics are covered:
- Introduction;
- Creating Reports;
- 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 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.
MOS Office 2016 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 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.
