Looking for a career upgrade & a better salary? We can help, Choose from our no 1 ranked top programmes. 25k+ career transitions with 400 + top corporate companies. Exclusive for working professionals: Link
Get your free certificate of completion for the Excel for Beginners Course, Register Now:https://glacad.me/3ehP0Lf
Today’s video discusses "Vlookup in Excel". In this video, we will learn the skills that will enable us to make the most effective and efficient use of Microsoft Excel. MS Excel is an industry-leading spreadsheet software and is a powerful analysis as well as a data visualization tool. Microsoft Excel includes many useful functions which can reduce our time and effort considerably. This session will comprehensively cover Vlookup in Excel. It is a beginner-friendly live session that aims at helping you get started with Microsoft Excel on the right note.
00:00:00 Introduction
00:01:35 Agenda
00:03:34 What is Vlookup?
00:05:35 Vlookup Function in the same sheet
00:09:46 Vlookup Function in a different sheet
00:11:45 Vlookup Function in a different workbook
00:13:53 Copy Vlookup Function
00:16:52 Multiple Values at once
00:19:19 Smallest and Largest Value
00:21:58 Summary
Visit Great Learning Academy, to get access to 300+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3duVMLE
Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl
About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.