4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
LOGIN
HOME / COURSE / MICROSOFT OFFICE / EXCEL / WORD / POWERPOINT / OUTLOOK / ACCESS / MICROSOFT OFFICE 2016 COMPLETE DIPLOMA LEVEL 3
Microsoft O Level 3 ( 10 REVIEWS )
ce 2016 Complete Diploma 539 STUDENTS
Are looking for a course that includes all the features of Microsoft O …
ce, then you have come to the right
TAKE THIS COURSE
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
1/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
£297.00
1 YEAR ADVANCED COURSE BADGE COURSE CERTIFICATE
149
NUMBER OF UNITS
2
NUMBER OF QUIZZES
3 DAYS, 5 HOURS
HOME
CURRICULUM
REVIEWS
Are looking for a course that includes all the features of Microsoft O ce, then you have come to the right place. The Microsoft O ce 2016 Complete Diploma Level 3 course provides you with the essential features and functions of the applications of Microsoft O ce 2016. The course is divided into ve sections where each section deals with a speci c 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 e ect, 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 o ers a complete guide for understanding the Microsoft O
ce 2016.
Course Highlights The price is for the whole course including nal exam – no hidden fees Accredited Certi cate upon successful completion at an additional cost E cient exam system with instant results Track progress within own personal learning portal https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
2/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
24/7 customer support via live chat Microsoft O ce 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 eld then Microsoft O ce 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 o er 3 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 quali cation. 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 quali cation and verify your certi cation on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential.
Assessment and Certi cation 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 nal exam, you will be able to order an Accredited Certi cate 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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
3/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
4/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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:15:00
Activity-Apply Conditional Formatting
00:05:00
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
5/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
6/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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 Di erent Workbooks
00:15:00
Activity-Link Cells in Di erent 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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
7/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
Activities – 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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
8/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
9/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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
Con gure 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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
10/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
11/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
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
00:30:00
00:30:00
Mock Exam
-
Mock Exam – Microsoft O
ce 2016 Complete Diploma Level 3
Final Exam
-
Final Exam – Microsoft O
ce 2016 Complete Diploma Level 3
COURSE REVIEWS
4.9 10 ratings
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
12/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
5 STARS
0
4 STARS
0
3 STARS
0
2 STARS
0
1 STARS
0
NO REVIEWS FOUND FOR THIS COURSE.
RELATED COURSES
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
13/20
4/11/2018
Microsoft O
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
ce 2016 Beginners Diploma
£299.00
509
Professional Microsoft Word 2016 Complete Diploma
£299.00
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
532
14/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
Microsoft Internet Explorer 6,7,8 Complete Diploma
£299.00 549
539 STUDENTS ENROLLED
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
15/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
16/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
ACCREDITING BY
AWARDING BODY
Registered with the UK Register of Learning Providers (UKRLP) UKPRN: 10063816
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
17/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
COURSES PARTNER
All Alpha Academy students are entitled to apply for an NUS card
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
18/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
OUR STUDENTS SAY.. Course content are awesome! Greatest An extremely helpful and informative course I had this time. course, especially in conjunction with quiz and video tutorial.
Ginny
Mike
Student
Student, Finance
Great Course Content! Learn anywhere using personal de Video is a good way to learn
Kiara Student
ABOUT We are a company who is best known for o ering 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 info@alphaacademy.org CERTIFICATE CODE Enter Certi cate Code
VALID ATE
IMPORTANT LINKS https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
19/20
4/11/2018
Microsoft Office 2016 Complete Diploma Level 3 - Alpha Academy
About Us Blog Terms & Conditions Privacy Policy Cookie Policy FAQ Upload CV Contact COMING SOON
© ALPHA ACADEMY
https://www.alphaacademy.org/course/microsoft-office-2016-complete-diploma-level-3/
20/20