• No products in the basket.

MS Office 2016 Advanced Level

5( 5 REVIEWS )
MS Office 2016 Advanced Level

Do you need to get to grips with Microsoft Office?

Course Description:

Microsoft Office is a suite of programs which are widely used in the world of work. If you work in an office environment you will almost certainly need to be able to use Microsoft Office, so its great to have a qualification on your CV proving you can use it. This course will give you a full introduction to Microsoft Office and moves on to more advanced features, so upon successful completion, you’ll be an expert,

Our online courses offer you the opportunity to study 24/7 wherever you are in the world. These intensive on line courses are open to anyone with an interest in the topic and give you access to world-class learning led by IAP.

What are the requirements?

  • You must be 16 or over
  • You should have a basic understanding of English and basic IT knowledge
  • You will need a computer or tablet with internet connection (or access to one)
  • You will need a computer with Microsoft Office installed on to it

What skills will I gain?

  • Learn master key Microsoft Office programs
  • Learn to produce standard documents using word
  • Gain knowledge of advance options of MS word
  • Become a master of MS excel worksheets
  • Gain knowledge of advance accounting calculations
  • Gain creative Power Point presentation skills
  • Gain a full understanding of database management
  • Become an expert in MS outlook e mail management system

What is the target audience?

  • Job hunters & School leavers
  • College or University student, graduates & Teachers
  • Personal assistant & Receptionist
  • Assistant for company director
  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Account assistance, Bookkeeper & Accountant
  • IT professionals & Businessman

How will I be assessed?

  • At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
  • Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

What Certification am I going to receive?

If you pass the exam successfully then you will be awarded a Microsoft Office 2016 Advanced Level Training Certificate.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Upon the successful completion of the course, you will be awarded the “Certificate in MS Office 2016 Advanced Level”.


Upon the successful completion of the course, you will be awarded the “Certificate in MS Office 2016 Advanced Level”.


Course Curriculum Total Units : 83
Microsoft Word 2016 - Beginner
Introduction to Microsoft Word
First Step to MS Word
Text Editing & Formatting
Formatting Paragraph and Pages
Creating Styles, Themes, Number and Bullets
Columns & Tables
Macros and Proofing
Sharing and Reviewing Documents
Modify Word Document
Exercise Files: Microsoft Word 2016
Microsoft Word 2016 - Advance Tricks and Tips
Introduction Word 2016 Advance Tricks and Tips
Set a Default Front for Documents
Text Replacement and Autoformat Options
Use Different Tools
Microsoft Excel 2016 - Beginner
Getting Started with Microsoft Excel
Data Entering
Creating Formulas and Functions
Worksheet Views, Multiple Worksheets and Workbooks
IF, VLOOKUP, and Power Functions, Security & Sharing
Data Management, Data Analysis Tools
PivotTables & Macros
Exercise Files: Microsoft Excel 2016
Microsoft Excel 2016 - Advance Formulas & Functions
Introduction to Excel 2016 Advance Formula and Functions
Values and Formulas
Operations in Formulas
IF, AND, OR and NOT Functions
Tabulating Data and Multiple Criteria
Median, Mode and Ranking Data
Date, Time and Functions
Array Formulas and Frequency Functions
Different TEXT & Information Functions
Exercise Files_Excel 2016 Advance Formulas & Functions
Microsoft Excel 2016 - Advance Formatting and Techniques
Introduction to Excel Advance Formatting & Techniques
Adjust Fonts, Font Sizes & Font Colours
Adjust Cells and Tools
Work with Formulas & Tables
Adjust Row, Columns and Sheets
Different Formatting Styles and Set up Data for Outlines
Formatting Picture Styles
Formatting Techniques – Restore Missing Data in a Column
Exercise Files_Excel 2016_Advance Formatting & Techniques
Microsoft PowerPoint 2016
Getting Started with Microsoft PowerPoint
Working with Presentations & Slides
Adding Pictures & Contents to Slides
Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides
Preparing & Delivering the Presentation
Reusing and Sharing Presentations
Exercise Files: Microsoft PowerPoint 2016
Microsoft Access 2016 - Beginner
Introduction to MS Access
Creating Tables & Setting up Properties
Creating Forms & Reports
Working with Macros, Integrating Access with Office Suite
Database Management
Exercise Files- Microsoft Access 2016
Microsoft Access 2016 - Advance Questions in Depth
Introduction to Access 2016 Advance Questions in Depth
Understanding Queries
Query Criteria
Parameters Queries
Use Mathematical Operations and Functions
Summarise Data with Aggregate Functions
Dates, Time and Numbers Functions
IF Function and Calculations
Records and Database
Explore the Basics of SQL
Values, Database and Markup
Microsoft Access 2016 - Advance Tricks and Tips
Introduction to Trick and Tips of Access 2016
Explore Startup Options
Embed Queries in Reports
Create a Back End and Front Ends
Build the Forms and Reports
Add Customised Functions and Visual Basics
Microsoft Outlook 2016
Getting Started with Outlook
Adding and Connecting Accounts, Reading & Organizing Mails
Creating and Sending Mail, Creating and Working with People
Working with Delegates & Calendars
Creating Tasks and Notes, Working with Outlook Data
Mock Exam
Mock Exam: Advanced Microsoft Office 2016 Training
Final Exam
Exam: Advanced Microsoft Office 2016 Training
Certificate Download Guide
Certificate Download Guide
WhatsApp chat