This Microsoft Office 2016 Excel Intermediate – Video Training builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Basic training series. In this course you will start down the road to creating advanced workbooks and worksheets that can help deepen understanding of organizational intelligence. You will also learn to work with charts and advanced formatting including styles, how to use formulas and functions. After getting this course you will be able to create and modify charts, convert, sort, filter, manage lists, insert and modify illustrations in a worksheet, work with tables, how to use conditional formatting and styles, and more. This Intermediate level will give you the additional advanced skills you need to become more valuable at work. You can get this course if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations.

Why Should You Choose Microsoft Office 2016 Excel Intermediate – Video Training

  • Internationally recognised accredited qualification
  • 1 year accessibility to the course
  • Free e-Certificate
  • Instant certificate validation facility
  • Properly curated course with comprehensive syllabus
  • Full-time tutor support on working days (Monday – Friday)
  • Efficient exam system, assessment and instant results
  • Access to the course content on mobile, tablet or desktop from anywhere anytime
  • Eligible for **Student ID** card which gives you 1000’s of discounts from biggest companies.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful in no time. You will be able to stand out in the crowd after completing this course. You will also be able to add our qualifications to your Resume and make yourself worthy in the competitive job industry.


Who is this course for?

There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.

Is this course accredited?

Yes, this course is accredited by CiQ and CPD Qualification Standards.

If I take the course, how will I be assessed?

Once you complete all the lessons/units, you are required to sit an exam which is multiple-choice. Pass mark is 60%.

Does this course include exams?

Yes, this course includes exams.

How can I achieve my certificate?

Once you successfully pass your exam you can obtain your certificate of achievement either in PDF or hard copy format, or both, for an additional fee.  Certificates are also available as e-certificates.

Is there any charge for certification?

Yes, there is an additional charge for the certification service.  Certificates are £4 each for PDFs and £8 each for hard copies. If both PDF and hard copy certificates are ordered at the same time, the cost is £10. E-certificates are available from your learning portal completely free of charge.

Can anyone validate my certificate through your website?

Yes, there is a unique code issued for every certificate and anyone can validate your certificate by using this code through our website.

Are there any prerequisites for the course?

There are no prerequisites for this course and it is open to everyone.

How long until I receive the course confirmation details?

Once you purchase a course your account will be set up within 48 hours and you will receive an email with your account details.

For how long do I have access to the course?

You will have access to the course for one year following purchase.

What support do you offer?

We provide 24 hours live chat support and our customer service team is available during working hours to answer your phone calls.

Course Curriculum

  • Working with Functions
  • Use Specialized Functions
  • 00:11:00
  • Work with Logical Functions
  • 00:23:00
  • Work with Date & Time Functions
  • 00:08:00
  • Work with Text Functions
  • 00:11:00
  • Working with Lists
  • Sort Data
  • 00:10:00
  • Filter Data
  • 00:10:00
  • Query Data with Database Functions
  • 00:09:00
  • Outline and Subtotal Data
  • 00:09:00
  • Analyzing Data
  • Create and Modify Tables
  • 00:15:00
  • Apply Intermediate Conditional Formatting
  • 00:07:00
  • Apply Advanced Conditional Formatting
  • 00:05:00
  • Visualizing Data with Charts
  • Create Charts
  • 00:13:00
  • Modify and Format Charts
  • 00:12:00
  • Use Advanced Chart Features
  • 00:12:00
  • Using PivotTables and PivotCharts
  • Create a PivotTable
  • 00:13:00
  • Analyze PivotTable Data
  • 00:12:00
  • Present Data with PivotCharts
  • 00:07:00
  • Filter Data by Using Timelines and Slicers
  • 00:11: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.

$456.05 $28.65

Accredited By —


30 Days – Money Back Guarantee

WordPress database error: [Unknown column 'hide' in 'where clause']
SELECT * FROM wp_grp_google_review WHERE google_place_id = 1 AND hide = '' AND language = 'en' ORDER BY time DESC /* From [] in [/nas/content/live/adamsa/wp-content/plugins/widget-google-reviews/grw-reviews.php:18] */

Our Students Say..