Microsoft Excel 2016 Advanced

Provided by

  • Subject Microsoft Office
  • Location Online
  • Qualification Course certificate
  • Price £1 - £250
  • Duration 365 days
  • Price £39 + VAT

Enquire about this course

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
 
01.
  1. Text Functions
02.
  1. Date & Time Functions
03.
  1. Recap
  2. Nested IF with =MAX() Function
  3. Max & Ifs – & And & OR Using If Function
  4. Nested IF with multiple Ifs
  5. IF functions with =AND() & =OR() functions
04.
  1. VLOOKUP To find the nearest match
  2. VLOOKUP To find an exact matc
05.
  1. MATCH & INDEX Functions
06.
  1. Data Validation
07.
  1. Protecting Worksheets & Workbooks
08.
  1. Working With Templates
09.
  1. Creating, rearranging and updating a Pivot Table
  2. Filtering and grouping data in a Pivot Table
  3. Slicers and timelines
  4. Creating a Pivot chart
10.
  1. Recording a macro in a macro-enabled workbook (using relative references)
  2. Running a macro and assigning it to objects
  3. Editing and deleting a macro
11.
  1. Conclusion

Benefits you will gain:

By enrolling in this course, you’ll get:

  • High-quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • Includes step-by-step tutorial videos and an effective, professional support service.
  • 24/7 Access to the Learning Portal.
  • The benefit of applying for NUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Access Course Content on Mobile, Tablet or Desktop.
  • A study in a user-friendly, advanced online learning platform.
  • Excellent customer service and administrative support.
 

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article