• No products in the basket.

  • LOGIN

Login

  • 230 Students

  • Certified

Learning Outcome

Description

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: Master Excel Formula VLOOKUP in 60 minutes! 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. 

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of:

    • Online study materials

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 certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

WHY STUDY THIS COURSE

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: Master Excel Formula VLOOKUP in 60 minutes! 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: Master Excel Formula VLOOKUP in 60 minutes! 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.

 

Course Curriculum

VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes!
Menu Example with Excel Vlookup 00:08:00
Wildcard Search with Excel Vlookup 00:09:00
Looking to the Left with Excel Vlookup 00:17:00
2-Way Lookup 00:14:00
Comparing Lists with Excel Vlookup 00:03:00
Microsoft Excel Vlookup Tips and Tricks 00:14:00
  • £425.00 ex Vat
  • 1 year
  • Number of Units6
  • Number of Quizzes0
  • 1 hour, 5 minutes

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2021 One Education