0 courses found

Microsoft Office

Microsoft Excel 2016 Advanced

Provided by

About the course

Who is it for?
  • This course is advanced level, so will be suitable for those who have used Excel before
  • Learners may wish to complete our Microsoft Excel 2016 Intermediate course first, but this is not compulsory.
Course Description:

This online training course is comprehensive and designed to cover the topics listed under the curriculum.

Method of Assessment:

At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certification:

Learners who successfully complete this course will be awarded a Microsoft Excel 2016 Advanced Certificate.

Entry Requirements:

Learners on this course must be over the age of 16 and should have a basic grasp of English, Maths and ICT. In addition you will need Microsoft Excel 2016 installed onto your computer / laptop / tablet.

PLEASE NOTE: We do not provide any software with this course, please acquire Microsoft Excel 2016 before you undertake the course.

Career Path:

As Excel is so widely used this course provides transferable skills that will be useful in a wide range of job roles, and could help you land your next job, or get a pay rise. The qualification will be of particular interest to anyone hoping to work in administration, accounting or bookkeeping.

Course Curriculum

Module 1 : Text Functions

Module 2 : Date & Time Functions

Module 3 : Understanding The Functions

Module 4 : Working With Vlookup

Module 5 : Match & Index Functions

Module 6 : Data Validation

Module 7 : Protecting Worksheets & Workbooks

Module 8 : Working With Templates

Module 9 : Exploring Pivot Tables

Module 10 : How To Work With A Macro?

Module 11 : Conclusion

 

Related article