About the course
- 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.
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.
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