Complete Microsoft Office 2016 Certification Bundle

These Internationally Recognised Certifications are for individuals who want to learn the skills to get the most out of Microsoft Office Products and obtain a Microsoft Office Master Certification.

These MOS Training courses helps you prepare for the Microsoft Office Suite Exams and builds a fundamental understanding of all the Microsoft Office Products.

In Word participants learn about creating and editing large projects which can include professional-looking reports, multi-column newsletters, résumés and business correspondence.

The Word Expert course builds an understanding of the advanced features of Word for Documents, Content Management and Advanced Formatting.

In Excel participants learn to create and edit a workbook with multiple sheets and use graphic elements to represent data visually including professional-looking budgets, financial statements, performance charts, and data-entry logs.

The Excel expert course builds an advanced understanding of Excel, by teaching you how to create, manage, and distribute professional spreadsheets for a variety of specialized purposes.

In PowerPoint participants learn to create, edit, and enhance PowerPoint presentations, including those for professional grade sales presentations, employee training, instructional materials, and business slideshows.

In Access participants learn about creating and maintaining basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries.

In Outlook participants learn how to manage the Outlook environment, manage messages, contacts and schedules.

The Word 2016 course will cover the following modules:

1. Understanding Word
2. Basic Editing
3. Character Formatting
4. Paragraph Formatting
5. Managing Text Flow
6. Creating Tables
7. Working with Themes, Style Sets, Backgrounds, Quick Parts and Text Boxes
8. Using Illustrations and Graphics
9. Formatting a Research Paper

The Word 2016 Expert course will cover the following modules:

1. Managing Document Changes
2. Advanced Editing and Formatting
3. Protecting and Sharing Documents
4. Customising Documents
5. Using Macros, QuickParts and Content Links
6. Using Fields, Forms and Indexes
7. Performing Mail Merges

The Excel 2016 course will cover the following modules:

1. Working with Microsoft Excel
2. Using Office Backstage
3. Using Basic Formulas
4. Using Functions
5. Formatting Cells and Ranges
6. Formatting Worksheets
7. Managing Worksheets
8. Working with Data and Macros
9. Using Advanced Formulas
10. Securing and Sharing Workbooks
11. Creating Charts
12. Adding Pictures and Shapes to a Worksheet

The Excel 2016 Expert course will cover the following modules:

1. Managing and Protecting Workbooks
2. Applying Custom Formatting and Layouts
3. Using Advanced Functions and Analysing Data
4. Working with Advanced Charts and PivotTables

The PowerPoint 2016 course will cover the following modules:

1. PowerPoint Essentials
2. Presentation Basics
3. Working with Text
4. Designing a Presentation
5. Adding Tables to Slides
6. Using Charts in a presentation
7. Creating SmartArt Graphics
8. Adding Graphics to a Presentation
9. Using Animation and Multimedia
10. Securing and Sharing a Presentation
11. Delivering a Presentation

The Access 2016 course will cover the following modules:

1. Database Essentials
2. Creating Database Tables
3. Working with Tables and Database Records
4. Modifying Tables and Fields
5. Creating Forms
6. Creating Reports
7. Creating and Modifying Queries
8. Using Controls in Reports and Forms
9. Advanced Tables
10. Advanced Forms
11. Advanced Reports
12. Advanced Queries
13. Displaying and Sharing Data
14. Importing and Exporting Data
15. Database Tools

The Outlook 2016 course will cover the following modules:

1. Manage the Outlook Environment for Productivity
2. Manage Messages
3. Manage Schedules
4. Manage Contacts and groups

To obtain an Internationally Recognised Microsoft Certification, participants will be required to complete the assessment process which consists of a 50 min online practical exam per course. This exam needs to be taken at a Certiport Testing Centre. Please see the Examination Process video for more information.