Are looking for a course that includes all the features of Microsoft Office, then you have come to the right place. The Microsoft Office 2016 Complete Diploma Level 3 course provides you with the essential features and functions of the applications of Microsoft Office 2016.

The course is divided into five sections where each section deals with a specific application.

Microsoft Word – teaches you to create the word document with charts, images and using other features.

Microsoft Excel – helps you to create and edit spreadsheet program by inserting and deleting text, adjusting cells, building columns, rows, etc.

Microsoft PowerPoint – shows you how to make a presentation with animation effect, adding charts, reference, statistics, etc.

Microsoft Outlook – guides you to use the email service.

Microsoft Access –  creates a database for administrative purposes.

In short, the course offers a complete guide for understanding the Microsoft Office 2016.

Course Highlights

  • The price is for the whole course including final exam – no hidden fees
  • Accredited Certificate upon successful completion at an additional cost
  • Efficient exam system with instant results
  • Track progress within own personal learning portal
  • 24/7 customer support via live chat

Microsoft Office 2016 Complete Diploma Level 3 has been given CPD and IAO accreditation and is one of the best-selling courses available to students worldwide.

This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you’re an individual looking to excel within this field then Microsoft Office 2016 Complete Diploma Level 3 is for you.

We’ve taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept – from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success.

All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges.

We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response.

Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime.

So, why not improve your chances of gaining professional skills and better earning potential.

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.

 

Career Path

Not only does our CPD and IAO accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one.

On successful completion of this course, you have the potential to achieve an estimated salary of £17,100.

The sky really is the limit.

Course Curriculum

Module - 1
Modify User Information 00:15:00
Share a Document 00:30:00
Work with Comments 00:15:00
Compare Document Changes 00:15:00
Review a Document 00:15:00
Merge Document Changes 00:15:00
Coauthor Documents 00:15:00
Add Captions 00:15:00
Add Cross-References 00:15:00
Add Bookmarks 00:15:00
Add Hyperlinks 00:15:00
Insert Footnotes and Endnotes 00:15:00
Add Citations 00:30:00
Insert a Bibliography 00:15:00
Insert Blank and Cover Pages 00:15:00
Insert an Index 00:30:00
Insert a Table of Contents 00:30:00
Insert an Ancillary Table 00:15:00
Manage Outlines 00:30:00
Create a Master Document 00:30:00
Suppress Information 00:30:00
Set Editing Restrictions 00:30:00
Add a Digital Signature to a Document 00:15:00
Restrict Document Access 00:15:00
Create Forms 00:30:00
Manipulate Forms 00:15:00
Form Data Conversion 00:15:00
Create a New Document Version 00:30:00
Compare Document Versions 00:15:00
Merge Document Versions 00:15:00
Activities – Microsoft Word 2016 Advanced 00:00:00
Module - 2
Update Workbook Properties 00:15:00
Activity-Update Workbook Properties 00:05:00
Create and Edit a Macro 00:15:00
Activity-Create and Edit a Macro 00:05:00
Apply Conditional Formatting 00:30:00
Activity-Apply Conditional Formatting 00:05:00
Add Data Validation Criteria 00:15:00
Activity – Add Data Validation Criteriaty 00:05:00
Trace Cells 00:15:00
Activity-Trace Cells 00:05:00
Troubleshoot Invalid Data and Formula Errors 00:15:00
Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00
Watch and Evaluate Formulas 00:15:00
Activity-Watch and Evaluate Formulas 00:05:00
Create a Data List Outline 00:15:00
Activity-Create a Data List Outline 00:05:00
Create Sparklines 00:15:00
Activity – Create Sparklines 00:05:00
Create Scenarios 00:15:00
Activity-Create Scenarios 00:05:00
Perform a What-If Analysis 00:15:00
Activity-Perform a What-If Analysis 00:05:00
Perform a Statistical Analysis with the Analysis ToolPak 00:15:00
Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00
Create Interactive Data with Power View 00:15:00
Activity-Create Interactive Data with Power View 00:05:00
Consolidate Data 00:15:00
Activity-Consolidate Data 00:05:00
Link Cells in Different Workbooks 00:15:00
Activity-Link Cells in Different Workbooks 00:05:00
Merge Workbooks 00:15:00
Activity-Merge Workbooks 00:05:00
Export Excel Data 00:15:00
Activity-Export Excel Data 00:05:00
Import a Delimited Text File 00:14:00
Activity- Import a Delimited Text File 00:05:00
Integrate Excel Data with the Web 00:15:00
Activity-Integrate Excel Data with the Web 00:05:00
Create a Web Query 00:15:00
Activity-Create a Web Query 00:05:00
Import and Export XML Data 00:15:00
Activity-Import and Export XML Data 00:05:00
Activities and Exercise Files – Microsoft Excel 2016 Advanced 00:00:00
Module - 3
Customize the User Interface 01:30:00
Set PowerPoint 2016 Options 00:45:00
Create and Manage Sections 01:00:00
Modify Slide Masters and Slide Layouts 01:15:00
Add Headers and Footers 00:30:00
Modify the Notes Master and the Handout Master 00:45:00
Create SmartArt 00:45:00
Modify SmartArt 01:00:00
Add Audio to a Presentation 00:45:00
Add Video to a Presentation 01:00:00
Customize Animations and Transitions 01:00:00
Add Comments to a Presentation 00:45:00
Review a Presentation 00:45:00
Store and Share Presentations on the Web 01:30:00
Annotate a Presentation 00:45:00
Set Up a Slide Show 00:45:00
Create a Custom Slide Show 00:30:00
Add Hyperlinks and Action Buttons 00:45:00
Record a Presentation 00:15:00
Secure a Presentation 01:30:00
Present a Slide Show Online 01:00:00
Create a Video or a CD 00:45:00
Activities – Microsoft PowerPoint 2016 Advanced Level 00:00:00
Module - 4
Insert Advanced Characters and Objects 01:30:00
Modify Message Settings, Properties, and Options 01:30:00
Use Automatic Replies 01:30:00
Sort Messages 00:45:00
Filter Messages 01:00:00
Organize Messages 02:00:00
Search Messages 01:30:00
Manage Junk Mail 01:00:00
Manage Your Mailbox 02:00:00
Manage Advanced Calendar Options 00:45:00
Manage Additional Calendars 01:00:00
Manage Meeting Responses 00:45:00
Assign and Manage Tasks 01:00:00
Edit an Electronic Business Card 01:00:00
Manage Advanced Contact Options 01:30:00
Forward Contacts 00:30:00
Export Contacts 01:00:00
Delegate Access to Mail Folders 01:00:00
Share Your Calendar 00:30:00
Share Your Contacts 00:15:00
Back Up Outlook Items 00:45:00
Change Data File Settings 00:45:00
Configure E-mail Message Security Settings 00:30:00
Activities – Microsoft Outlook 2016 Advanced Level 00:00:00
Module - 5
Add Controls to Forms 01:00:00
Set Form Controls 01:00:00
Create Subforms 00:30:00
Organize Information with Tab Pages 00:30:00
Enhance Navigation with Forms 00:30:00
Format a Form 01:00:00
Apply Conditional Formatting 00:30:00
Field Validation 00:30:00
Form and Record Validation 00:30:00
Create a Macro 01:00:00
Restrict Records Using a Condition 00:30:00
Validate Data Using a Macro 00:30:00
Automate Data Entry Using a Macro 00:30:00
Convert a Macro to VBA 00:30:00
Link Tables to External Data Sources 00:30:00
Manage a Database 00:30:00
Determine Object Dependency 00:30:00
Document a Database 00:30:00
Analyze the Performance of a Database 00:30:00
Split a Database for Multiple User Access 00:30:00
Implement Security 00:30:00
Set Passwords 00:30:00
Convert an Access Database to an ACCDE File 00:30:00
Package a Database with a Digital Signature 00:30:00
Create a Database Switchboard 01:00:00
Modify a Database Switchboard 00:30:00
Set Startup Options 00:30:00
Activities – Exercise Files for Microsoft Access 2016 Professional Diploma 00:00:00
Mock Exam
Mock Exam – Microsoft Office 2016 Complete Diploma Level 3 00:30:00
Final Exam
Final Exam – Microsoft Office 2016 Complete Diploma Level 3 00:30:00

Course Reviews

4.9

4.9
10 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

551 STUDENTS ENROLLED

Alpha-Academy-Certificate-Mockup1

Accredited by

 

alpha Academy - Accrediting Body 1

Centre Approved by

Alpha Academy - Awarding Body

Registered with the UK Register of Learning Providers (UKRLP)
UKPRN: 10063816

Courses Partner

 

 

Our Students Say..

About

We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level.

 11 Floor, 15 St Botolph Street, London EC3A 7BB
020 3965 2556
[email protected]

Certificate Code

Coming Soon

   

top
© Alpha Academy is a part of Adams Academy Inc. Ltd.
Select your currency
EUR Euro