Exact lookup using VLOOKUP Function in Microsoft Excel
- Understanding Excel
- Use Excel's basic formulas & functions
VLOOKUP is probably the most used function in excel. In this VLOOKUP course, We introduces you to the most simplest way to understand VLOOKUP function.
This course starts with understanding of VLOOKUP syntax. Then it will show you how to use VLOOKUP function is a List, Multi-Sheet / Multi-Workbook and then gradually moves to the using of VLOOKUP with other functions.
This course will fully benefit, if you download the exercise files, and practice it yourself.
I always tell my students that learning Microsoft Excel is like driving, you can't learn it till you drive yourself, so it is totally true for Microsoft Excel, that you don't learn it till the time you do it yourself, hands-on.
By the completion of this course, you will be fully versed, and capable of using VLOOKUP function in Microsoft Excel.
- Microsoft Excel users
- Microsoft Excel users who want to have grip on VLOOKUP Function of Microsoft Excel
- Introduction to VLOOKUP01:45
- Syntax of VLOOKUP04:03
- Writing your first VLOOKUP Function03:05
- Writing VLOOKUP with Absolute Reference for Lists03:40
- Using Range Lookup for VLOOKUP Function01:50
- Writing a multi-sheet VLOOKUP03:33
- Writing VLOOKUP in a multi-workbook setup.04:16
- VLOOKUP with MATCH03:01
- VLOOKUP with IFERROR02:31
- VLOOKUP with wildcards01:49
- VLOOKUP multiple columns02:11
- VLOOKUP for specific occurrence03:19
Nooruddin Surani is an MBA in MIS, a Microsoft Certified Trainer for Office 2007 Master Program, Microsoft Excel 2010, Microsoft Excel 2013, Brainbench Master Certified for Excel 2007 (ranking 4 in world) and a Certified Information Systems Auditor (CISA). His vibrant personality combined with a unique blend of content and delivery makes the participants’ experience both educating and entertaining.
Surani has been associated with the application of Information Technology for more than 18 years and is actively involved in training and teaching as a visiting faculty with multiple reputable institutes.
Surani’s unique experience of working with the corporate sector includes designing & development of software solutions for medium to large sized industries, retail business management, educational, financial and banking institutions. After being engaged in consultancy assignments for leading organizations, Surani is thoroughly able to inspire and encourage those around him through his unique training style which enables maximum learning & retention in least possible time.
Besides being an ardent trainer, Surani also has to his credit several articles published in multiple IT related publications. Currently, he is working as the Chief Operating Officer at Viftech Solutions (Pvt.) Ltd., a software & information technology solution provider. Driven by a mission in life, Surani aims to provide better understanding to his participants enabling them to focus better and achieve the results they seek!