Great Learning
Great Learning Logo

VLOOKUP in Excel 

  • Offered byGreat Learning

VLOOKUP in Excel
 at 
Great Learning 
Overview

Duration

1 hour

Total fee

Free

Mode of learning

Online

Difficulty level

Beginner

Official Website

Explore Free Course External Link Icon

Credential

Certificate

VLOOKUP in Excel
 at 
Great Learning 
Highlights

  • Earn a certificate of completion
Details Icon

VLOOKUP in Excel
 at 
Great Learning 
Course details

What are the course deliverables?
  • Excel VLOOKUP
  • Excel Formulas
  • Excel Functions
  • MS Excel
More about this course
  • This VLOOKUP in Excel will come in handy when you want to find things in a large spreadsheet or when you are looking for the same type of information
  • In this free VLOOKUP Excel course, you will understand the agenda of the formulas and functions
  • You will get a brief on the formula in Excel and how to enter it to implement it successfully
  • You will learn about the precedence order of operations
  • You will know how to enter, copy, edit, and hide formulas in Excel
  • You will further understand the function in the workbook
  • You will go through a quick summary of formulas and functions you have learned till now
  • You will next start with knowing about the agenda for the VLOOKUP function
  • Following this, you will understand what is VLOOKUP in Excel
  • You will learn about multiple cases like the VLOOKUP function in the same sheet, different sheets, and different workbooks
  • By understanding all these scenarios, you will get a clear picture of how to use VLOOKUP in Excel
Read more

VLOOKUP in Excel
 at 
Great Learning 
Curriculum

Agenda to Formulas and Function

What is a Formula in Excel

How to enter a formula

Precedence order of operations

How to Enter, Copy, Edit and Hide a Formula

What is a Function

Function in workbook

Summary on Formulas and Functions

Agenda to Vlookup Function

What is Vlookup

Vlookup function in the same sheet

Vlookup function in a different sheet

Vlookup function in a different workbook

Copy Vlookup Function

Multiple Values at once

Smallest and Largest Value

Summary on Vlookup Function

Other courses offered by Great Learning

3.5 L
5 months
– / –
97 K
4 months
– / –
2.75 L
12 months
– / –
2.75 L
12 months
– / –
View Other 1225 CoursesRight Arrow Icon

VLOOKUP in Excel
 at 
Great Learning 
Students Ratings & Reviews

4.9/5
Verified Icon15 Ratings
S
Suchita Jambu
VLOOKUP in Excel
Offered by Great Learning
5
Learning Experience: This course gives good understanding of function .
Faculty: Faculty communication is very clear . Course is updated and easy to understand .
Reviewed on 5 Dec 2022Read More
Thumbs Up IconThumbs Down Icon
B
Bijendra Kumar Mahto
VLOOKUP in Excel
Offered by Great Learning
5
Learning Experience: Feeling confident with the software, i have no doubt it will help me and i am happy with this course completion. I used it often at school, for basic claculations and for the purpose of making illustrated charts for school presentations.
Faculty: Faculty lectures are good understaning lectures and good practical knowledge all the lecturers and best describe to topic clearly. All the assessments are good understanding to all the tutorial on this course and course structure are describe all the topics clear deeply to undrstood this course very well.
Course Support: Good experience in this course
Reviewed on 4 Nov 2022Read More
Thumbs Up IconThumbs Down Icon
P
PRANSHU KAUSHAL
VLOOKUP in Excel
Offered by Great Learning
5
Learning Experience: Great learning provides great platform for learners keen to learn new skills and they provide most of the courses for free and the great thing is that when you complete that course right away you get the certificate of that particular course. In my point of view thats the great thing and most of the candidates are looking for it only to boost their career and their teaching method is excellent you will understand on the one go apart from that u can easily toggle down the video and most imp thing u can create notes on that particular topic on the same lecture. That such a great learning platform.
Faculty: Faculty is great and their teaching methodology is excellent Yes they have new curriculum according to demand and when you get satisfy by the topic then u can give assessment and clear the test
Course Support: No that mostly a learning platform u can gain knowledge their for free and get certified
Reviewed on 8 Oct 2022Read More
Thumbs Up IconThumbs Down Icon
S
Suraj Harake
VLOOKUP in Excel
Offered by Great Learning
4
Learning Experience: Course i did mis where i learn vlook up
Faculty: Best quality at udemy. Online recorded videos available I learn on udemy is online platform
Course Support: No
Reviewed on 5 Sep 2022Read More
Thumbs Up IconThumbs Down Icon
G
Ganga Keshri
VLOOKUP in Excel
Offered by Great Learning
5
Learning Experience: learned about shortcut tricks, vlookup function and excel related works
Faculty: i won't remember course Curriculum was good, i understood the chapter very well
Course Support: not yet
Reviewed on 2 Sep 2022Read More
Thumbs Up IconThumbs Down Icon
View All 9 ReviewsRight Arrow Icon
qna

VLOOKUP in Excel
 at 
Great Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...