Master VLOOKUP & HLOOKUP Functions Using Examples – MS Excel

Increase Your Productivity & Impress Your Colleagues Using VLOOKUP & HLOOKUP Formulas professionally – Beginner To Pro

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.

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..

Course Content

  • Introduction –> 2 lectures • 7min.
  • VLOOKUP Structure –> 3 lectures • 10min.
  • LOOKUP Formulas –> 2 lectures • 24min.
  • LOGICAL Functions –> 1 lecture • 10min.

Master VLOOKUP & HLOOKUP Functions Using Examples - MS Excel

Requirements

  • Pen & Notebook to take notes..
  • Excel Basic Knowledge..

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.