• No products in the cart.

Microsoft Office 2016 Advanced Training

4.9( 10 REVIEWS )

Gain a comprehensive, expert understanding of industry-standard office administration software with this engaging online course. Through video tutorials and practical exercises you will develop your skills in Microsoft Office programs including Word, Excel and Powerpoint, with the versatility to turn your expertise to almost any office or business administration role, personal projects, or other PA, receptionist and secretarial careers.


Microsoft Office is one of the most popular bundles of PC software in the world, with over 1 billion copies sold since its initial release. The programs have become the standard for businesses across all industries, of all sizes. This distance learning course will teach you how to advanced your skills and comprehension of the Microsoft Office programs. You will learn how to perform advanced functions in Microsoft Excel spreadsheets, master your Outlook inbox, produce dynamic presentations in PowerPoint, and manage complex databases using Access.

Benefits of studying the Microsoft Office 2016 Advanced Training course with Victoria Education include

  • Easy-to-understand course materials designed by industry experts, accessible through your smartphone, laptop, desktop or tablet device
  • No hidden fees or costs — study a comprehensive course and earn a professional e-certificate upon successful completion
  • Get instant feedback from automated assessments and mock exams to gauge your progress
  • No formal deadlines or teaching schedule, meaning you can learn at your own pace
  • 24/7 help and support from your online tutors, through email and via our live online chat
  • Qualify for an NUS Extra card and gain access to over 200 fantastic deals from high street brands and one free year of ISIC unlocking over 42,000 international discounts

How is this qualification is delivered?

Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.

The courses are delivered through

  • Video lessons
  • PDF handouts
  • Mock exams
  • Online assessment

These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.

Mandatory units

The Microsoft Office 2016 Advanced Training consists of five mandatory modules

  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Outlook
  • Microsoft Access


The assessment at the end of each course is a multiple-choice exam taken through our online platform. The system is fully automated so you will receive your results instantly upon completion.


Upon successful completion you will qualify for the UK and internationally-recognised professional qualification. You can order a PDF Certificate for £12.

Who is this course for?

The Microsoft Office 2016 Advanced Training is aimed at anyone wishing to start working in such roles, or existing professionals wishing to boost their skills and employability.

Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT.

Career path

Studying this would benefit a range of careers, but would specifically boost employability in roles such as

  • Business Administration
  • Admin, PA and Secretary
  • Receptionist
  • Office Administration
  • Project Management
  • Entrepreneur

Course Curriculum

Section 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 Office 2016 Advanced Training 00:00:00
Section 2
Customising the properties of your workbook 00:15:00
Exercise: Customising the properties of your workbook 00:05:00
Inserting and updating a macro 00:15:00
Exercise: Inserting and updating a macro 00:05:00
Understanding conditional formatting 00:15:00
Exercise: Understanding conditional formatting 00:05:00
Applying data validation to your worksheet 00:15:00
Exercise: Applying data validation to your worksheet 00:05:00
Using the trace cells function 00:15:00
Exercise: Using the trace cells function 00:05:00
Understanding common formula errors and invalid data 00:15:00
Exercise: Understanding common formula errors and invalid data 00:05:00
Using watch windows and evaluating data 00:15:00
Exercise: Using watch windows and evaluating data 00:05:00
Isolate data lists and create outlines 00:15:00
Exercise: Isolate data lists and create outlines 00:05:00
Using sparkline tools 00:15:00
Exercise: Using sparkline tools 00:05:00
Forecasting with the scenario manager tool 00:15:00
Exercise: Forecasting with the scenario manager tool 00:05:00
How to undertake a what-if analysis 00:15:00
Exercise: How to undertake a what-if analysis 00:05:00
Using the Data Analysis ToolPak 00:15:00
Exercise: Using the Data Analysis ToolPak 00:05:00
How to create a Power View 00:15:00
Exercise: How to create a Power View 00:05:00
Using Excel’s consolidation functions 00:15:00
Exercise: Using Excel’s consolidation functions 00:05:00
How to link cells across workbooks 00:15:00
Exercise: How to link cells across workbooks 00:05:00
Merging your workbooks 00:15:00
Exercise: Merging your workbooks 00:05:00
Exporting your data 00:15:00
Exercise: Exporting your data 00:05:00
Importing data into Excel 00:14:00
Exercise: Importing data into Excel 00:05:00
Integrate Excel Data with the Web 00:15:00
Exercise: Publishing an Excel sheet online 00:05:00
Making web queries 00:15:00
Exercise: Making web queries 00:05:00
How to import and export XML data 00:15:00
Exercise: How to import and export XML data 00:05:00
Exercises: Microsoft Excel Advanced 00:00:00
Section 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 Office 2016 Advanced Training 00:00:00
Section 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 Office 2016 Advanced Training 00:00:00
Section 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 – Microsoft Office 2016 Advanced Training 00:00:00
Mock Exam
Final Exam

Course Reviews


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

No Reviews found for this course.

  • £297.00 £45.00
  • 1 year
  • Course Badge
  • Course Certificate
  • Number of Units149
  • Number of Quizzes0
  • 3 days, 4 hours


    © Victoria Education Ltd.