Exact lookup using VLOOKUP Function in Microsoft Excel
- Understanding Excel
- Use Excel's basic formulas & 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.
- Microsoft Excel users
- Microsoft Excel users who want to have grip on VLOOKUP Function of Microsoft Excel
- Introduction to VLOOKUP
- Syntax of VLOOKUP
- Writing your first VLOOKUP Function
- Writing VLOOKUP with Absolute Reference for Lists
- Using Range Lookup for VLOOKUP Function
- Writing a multi-sheet VLOOKUP
- Writing VLOOKUP in a multi-workbook setup.
- VLOOKUP with MATCH
- VLOOKUP with IFERROR
- VLOOKUP with wildcards
- VLOOKUP multiple columns
- VLOOKUP for specific occurrence
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!