Download Now

Excel Crash Course  VLOOKUP, HLOOKUP, and LOOKUP Functions
Excel Crash Course: VLOOKUP, HLOOKUP, and LOOKUP Functions
MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 1.5 Hours | Lec: 17 | 165 MB
Genre: eLearning | Language: English


Learn to use some of the most popular Excel functions for tabular lookups. Learn VLOOKUP, HLOOKUP, and LOOKUP functions.

VLOOKUP is one of the most requested Excel function tutorials that I've received in over eight years of providing corporate training in WeiRuan-->WeiRuan 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

Download link

Mirror Links

Direct Download

Tags: Course, VLOOKUP, HLOOKUP, LOOKUP, Functions

Add Comments:
Enter Code: *