• No products in the basket.

What Will I Learn?

Use Advanced IF Statements

Use Advanced Lookup Functions

Use Complex Logical and Text Functions

Process monthly pay

Auditing Formulas

Working with What-If Analysis Tools

Protecting Worksheet and Workbook

Use Advanced PivotTables and PowerPivot Tools

Automate with Macros

Work with Form Controls

Ensure Data Integrity

Import and Export Data to a Text File

Welcome To Excel 2016 Advanced

Course Overview

In this day and age can you imagine an office without Excel! No matter what profession you have, good Microsoft Excel skills will always come in handy. The Excel 2016 Advanced course is designed to show the learners A-Z of Excel 2016 to turn them into expert users.

This course is packed in 65 easy to follow modules to help you understand all the tools and functions of Excel 2016. This course will guide you through using advanced if statements, automating with macros and formula auditing. You will also learn about complex text functions. During this course, you will have the opportunity to take an assessment to consolidate your learning.

If you desire to comprehend all the advanced Excel 2016 skills, then this is the course. Upon completing this course, you will be able to raise your proficiency level and bring out your all potentials. So don’t delay, enrol today!

Excel 2016 Advanced is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector. 

This course is accredited by CPD so you will get a career boost upon completing this course. Our Excel 2016 Advanced is packed with 65 modules and 3 hours, 1 minute of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.

It doesn’t matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime. 

Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.



After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Course Curriculum

Introduction 00:01:00
Using Advanced IF Statements
Summarize Data with SUMIF 00:04:00
Summarize Data with AVERAGIF 00:03:00
Summarize Data with COUNTIF 00:02:00
Using Advanced Lookup Functions
Using VLOOKUP with TRUE to find an Approximate Match 00:04:00
Using HLOOKUP TRUE to find an Approximate Match 00:01:00
Using the Index Function 00:03:00
Using the Match Function 00:02:00
Creating a Combined Index and Match Formula 00:04:00
Comparing Two Lists with VLOOKUP 00:02:00
Comparing Two Lists with VLOOKUP and ISNA 00:04:00
Using Complex Logical and Text Functions
Creating a Nested IF Function 00:03:00
Using the IFERROR Function 00:02:00
Using the LEN Function 00:02:00
Using the TRIM Function 00:01:00
Using the Substitute Function 00:02:00
Formula Auditing
Showing Formulas 00:01:00
Tracing Cell Precedents and Dependents 00:03:00
Adding a watch Window 00:02:00
Error Checking 00:02:00
What-If Analysis Tools
Using the Scenario Manager 00:03:00
Using Goal Seek 00:02:00
Analyzing with Data Tables 00:02:00
Worksheet and Workbook Protection
Protection Overview 00:02:00
Excel File Password Encryption 00:03:00
Allowing Specific Worksheet Changes 00:01:00
Adding Protection to only Certain Cells in a Worksheet 00:03:00
Additional Protection Features 00:02:00
Advanced Use of PivotTables and PowerPivot
Using the Pivot Tables Charts Wizard 00:02:00
Adding a Calculated Field 00:02:00
Adding a Caculated Item 00:02:00
Apply Conditional Formatting to a Pivot Table 00:03:00
Using Filters in the Pivot Table Fields Pane 00:02:00
Creating Filter Pages for a Pivot Table 00:01:00
Enabling a Power Pivot Add In 00:04:00
Automating with Macros
What are Macros 00:03:00
Displaying the Developer Tab and Enabling Macros in Excel 00:03:00
Creating a Basic Formatting Macro 00:03:00
Running a Macro 00:02:00
Assigning a Macro to a Button 00:02:00
Creating a More Complex Macro 00:02:00
Viewing and Editing the VBA Code for an Existing Macro 00:03:00
Adding a Macro to the Quick Access Toolbar 00:02:00
Working with Form Controls
What are Form Controls 00:02:00
Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00
Adding a Combo Box to a Spreadsheet 00:02:00
Ensuring Data Integrity
What is Data Validation 00:01:00
Restricting Data Entries to Whole Numbers 00:02:00
Data Validation Restricting Data Entry to a List 00:01:00
Data Validation Restricting Data Entry to a Date 00:01:00
Data Validation Restricting Data Entry to Different Text Lengths 00:01:00
Composing Input Messages 00:02:00
Composing Error Alters 00:02:00
Finding Invalid Data 00:02:00
Editing and Deleting Data Validation Rules 00:01:00
Collaborating in Excel
Working with Comments 00:03:00
Printing Comments and Errors 00:02:00
Sharing a Workbook 00:03:00
Tracking Changes in a Workbook 00:03:00
Working with Versions 00:02:00
Sharing Files via Email 00:02:00
Importing and Exporting Data to a Text File
Importing a Text File 00:03:00
Exporting a Text File 00:01:00
Course Recap 00:01:00
Course Certification
Order your Certificate 00:00:00
Mock Exam
Mock Exam – Excel 2016 Advanced 00:20:00
Final Exam
Final Exam – Excel 2016 Advanced 00:20:00


Course Reviews


38 ratings
  • 5 stars3
  • 4 stars2
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Nicole Higgins


    “Nice course!! Best vlue for the price.

  2. Joe Welch


    “Enjoyed the course. Recommended

  3. Leah Alexander


    Thank You so much for this course. Very engaging and useful. Highly recommended

  4. Corey Vincent


    First course with Course Cloud. satisfied

  5. Nicole Page


    “Easy to learn and nicely designed. I purchased two courses together, hope the next one will be good also.


  • 1 Coldbath Square, Farringdon, London, EC1R 5HL
  • 02037432362



Partnered with

Course Cloud is an online learning platform that provides one of the best e-learning experience. With a large variety of training courses to choose from, you are bound to find something to suit you.

© Copyright Course Cloud