Master VLOOKUP & HLOOKUP Functions Using Examples - MS Excel

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 8 lectures (50 mins) | Size: 432 MB

Increase Your Productivity & Impress Your Colleagues Using VLOOKUP & HLOOKUP Formulas professionally - Beginner To Pro
What you'll learn

How to use VLOOKUP & HLOOKUP functions at a basic and advance level.
Learn the whole lookup functionality from Microsoft Excel expert.
Learn how to combine VLOOKUP & HLOOKUP with IFERROR and other powerful features.
Learn how to troubleshoot & solve VLOOKUP errors.
How to add data validation to make your VLOOKUP & HLOOKUP Formulas more easier to use
Understand VLOOKUP & HLOOKUP parameters and arguments.
Understand Exact and Approximate Match argument.
Be able to deal with any data set using VLOOKUP & HLOOKUP functions.
Learn how to create IF function with LOOKUP functions.

Requirements

Pen & Notebook to take notes.
Excel Basic Knowledge.

Description

You are now reading the description of one of the most important courses that deal in an easy-to-understand manner with the two most powerful functions in Microsoft Excel, VLOOKUP & HLOOKUP functions.

In this special course, you will learn & master the most important formulas of Excel. The version of MS Excel I'm using in the course is Microsoft Excel 2016 which is similar to Microsoft Excel 2019 & Office 365 Excel.

I note that the course is compatible at 95% with Microsoft Excel 2007, 2010, and 2013 versions.

The Course is very rich in information that will make you Professional in using VLOOKUP & HLOOKUP functions.

The course is structured into 03 Sections.

In Section 1 :

We will Introduce VLOOKUP & HLOOKUP functions course;

We also going to see the VLOOKUP definition;

We will learn the Fundamentals of VLOOKUP & HLOOKUP ;

In Section 2 :

We will see VLOOKUP and HLOOKUP structure;

We will talk about VLOOKUP & HLOOKUP Arguments in detail;

We going to see and analyze the LOOKUP Data Set;

We going to talk about VLOOKUP User Form etc...

In Section 3,

We going to create a VLOOKUP function with examples

We going to create an HLOOKUP function with examples

We going to use the IF function with both VLOOKUP & HLOOKUP functions to solve some errors like the #N/A error.

We will use Data Validation with that functions in order to simplify their use.

We will Deal With VLOOKUP Errors Using the IF Formula.

We will talk about Approximate Match & Exact Match.

Upon completion of this course, you will be able to master the use of VLOOKUP & HLOOKUP, besides the IF function and Data Validation.

So what are you waiting for? Enroll Now, and take a step towards becoming an Excel Expert on Using LOOKUP functions.

I'll love to see you in the class.

Who this course is for:

Anyone who doesn't understand VLOOKUP & HLOOKUP function in Excel.
Experts who want to freshen up their skills.
Beginners, Students, employees, managers, bosses and Professionals.