Price: AED 73
- Duration: Flexible
Course details
VLOOKUP is one of the most requested Excel function tutorials that I've received in over eight years of providing corporate training in Microsoft Excel. All too often, professional Excel users get caught up in inefficient and problematic workflows, and nested conditionals (nested IF statements) are certainly towards the top of the list. Learn to solve this, and other problems, by utilizing the VLOOKUP, HLOOKUP, and LOOKUP functions.
Some of the abilities you'll gain by understanding these functions are:
- Eliminate nested conditional (IF) statements
- Pull data from disjointed or broken tables
- Allow for autofill even when a reference table is transposed
- Create scalable drop-down validation lists
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- MS Office 2016 Excel for Beginners One EducationAED 70
AED 1,469Duration: Upto 5 Hours - Level 3 Diploma in Microsoft Excel John AcademyAED 93
AED 1,469Duration: 33 Hours
