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.
