Excel Crash Course: VLOOKUP, HLOOKUP, and LOOKUP Functions
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn to use some of the most popular Excel functions for tabular lookups. Learn VLOOKUP, HLOOKUP, and LOOKUP functions.Description
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
Requirements
- Requirements
- Basic computer usage skills involving the mouse and keyboard
- Access to Microsoft Excel version 2013 or newer
- Minimal proficiency with Excel including absolute and relative references, as well as the use of functions
Create Excel apps with MySQL & Virtual Forms & Excel VBA
- 3.5
-
![]()
![]()
![]()
![]()
![]()
Step-by-step Masterclass: Create quickly Excel VBA desktop apps using MySQL & Virtual Forms & VBA Excel 2010, 2013, 2016 One basic, simple Excel example....
Zero to Hero in Microsoft Excel: Complete Excel guide 2021
- 4.5
-
![]()
![]()
![]()
![]()
![]()
A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks 6 Reasons why you should choose this Excel course...
Excel 2019: The Ultimate Guide to Excel VLOOKUP
- 0.0
-
![]()
![]()
![]()
![]()
![]()
15 Essential things you should know about LOOKUP functions Learn Basics to Advanced use of excel VLOOKUP function. This course is on MS Excel VLOOKUP function....
Problem Solving with Excel
- 4.7
-
![]()
![]()
![]()
![]()
![]()
This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration....
