HOME
 

Microsoft Excel 2016 Advanced

Global Edulink
Course summary
Online courses
Next available date: Contact for dates - Online courses
Professional Training

Course description

Microsoft Excel 2016 Advanced:

Microsoft Excel 2016 Advanced

Course Overview

Created by a highly skilled professional, this course will guide learners through Microsoft Excel 2016. This computer program is commonly used in the world of work, so no matter what industry you hope to break into, this course will give your CV a boost. Whether you’re someone who is already working, or if you’re just starting out, this course is packed with useful information to help you succeed

This course covers advanced level functions of Microsoft Excel, such as data validation, slicers and timelines, and the running a macro. If you’re someone who has used Excel before, but you don’t know how to get the most out of it, then this course is for you. So, become a master of Excel with Global Edulink today.

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.

Course Curriculum

01.

  • Text Functions

02.

  • Date & Time Functions

03.

  • Recap
  • Nested IF with =MAX() Function
  • Max & Ifs – & And & OR Using If Function
  • Nested IF with multiple Ifs
  • IF functions with =AND() & =OR() functions

04.

  • VLOOKUP To find the nearest match
  • VLOOKUP To find an exact match

05.

  • MATCH & INDEX Functions

06.

  • Data Validation

07.

  • Protecting Worksheets & Workbooks

08.

  • Working With Templates

09.

  • Creating, rearranging and updating a Pivot Table
  • Filtering and grouping data in a Pivot Table
  • Slicers and timelines
  • Creating a Pivot chart

10.

  • Recording a macro in a macro-enabled workbook (using relative references)
  • Running a macro and assigning it to objects
  • Editing and deleting a macro

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.

Benefits you will gain:

  • High quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • 24/7 Access to the Learning Portal.
  • Benefit of applying NUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Excellent customer service and administrative support.

Suitability - Who should attend?

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.

Outcome / Qualification etc.

Non-accredited external qualification

Customer Outreach Award 2019

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

Global Edulink - together, shaping your future

Global Edulink - together, shaping your future

Global EduLink, located at the heart of London, is a pioneer in online education for UK learners and other learners across the globe. With over 224,000 happy learners, Global EduLink makes sure that your requirements are met by proving you...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel 2016 Advanced.

  Contact the provider

  Get more information

  Register your interest

Contact info

Global Edulink

CityPoint, 1 Ropemaker Street
EC2Y 9HU London

 Show phone number
globaledulink.co.uk


Request information

Find out more about this Microsoft Excel 2016 Advanced course - simply fill out your details:

What do you want to know more about?
Do you offer this course online/virtually
I want to know more about this course
I want to book this course
Do you offer discounts on more than one applicant?
I have another question
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here