reed.co.uk Courses

Header

VLOOKUP (Microsoft Excel) Training

Master VLOOKUP in Just 60 Minutes | Interactive Video Lessons | Instant Certificate | 2 CPD Points | 24x7 Access


One Education

Summary

Price
Save 97%
£10 inc VAT (was £425)
Offer ends 05 December 2020
Study method
Online, self-paced
Duration
1 hour
Access to content
12 months
Qualification
No formal qualification
CPD
2 CPD hours / points
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Add to basket or enquire

Overview

Are you someone who’s always overwhelmed and frightened while working on a spreadsheet? It’s normal to get a bit scared seeing all the complex functions and formulas the first time. But it doesn’t always have to be that way.

Jobs these days need you to be very able to freely and fluently use Excel to keep track of all the running tasks and calculations. So if you are ready to take full control over your Excel skills join our VLOOKUP (Microsoft Excel) Training Course to get you off the ground. This course presents all the essential formulas in clear and concise way for Its learners. So why wait! Get rid of your uneasiness on Excel forever.

The course is designed for opting to learn VLOOKUP on MS Excel. Microsoft Excel is platform for calculation, analysis, and visualization of data and information. VLOOKUP is an Excel function to look up data in a table organized vertically. It is a function that makes Excel search for a certain value in a column called ‘table array’, in order to return a value from a different column in the same row. The main advantage of VLOOKUP is you can extract data from a table based on a particular value. This reduces space in the spreadsheet and enhances presentation.

The course will include lessons on the basics of Excel VLOOKUP and how to compare lists. With VLOOKUP you can only look for values vertically the course will also teach you the trick to look for data from left to right and 2-way lookups.

CPD

2 CPD hours / points
Accredited by CPD Accreditation Group

Course media

Description

Course Curriculum

We’ve taken this comprehensive VLOOKUP (Microsoft Excel) Training Course and broken it down into manageable 06 units which we believe will assist you to easily grasp each concept – from the fundamental to the most advanced aspects of this skills. It really is a sure pathway to success.

This course is designed with the following 06 units:

Introduction

VLOOKUP (Microsoft Excel) Training

  • Menu Example with Excel Vlookup
  • Wildcard Search with Excel Vlookup
  • Looking to the Left with Excel Vlookup
  • 2-Way Lookup
  • Comparing Lists with Excel Vlookup
  • Microsoft Excel Vlookup Tips and Tricks

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Who is this course for?

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The VLOOKUP (Microsoft Excel) Training Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Requirements

Our VLOOKUP (Microsoft Excel) Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.

Modals

Mobile Navigation