Excel 2013: Mastering Vlookup and Hlookup Functions

Excel 2013: Mastering Vlookup and Hlookup Functions, available at $19.99, has an average rating of 4.5, with 7 lectures, based on 5 reviews, and has 40 subscribers.

You will learn about Understand how data lookups work in Excel Use VLookup and HLookup Functions easily Adopt a Structured Approach when using the lookup functions This course is ideal for individuals who are Anybody from a newbie to an advanced user can take this course It is particularly useful for Anybody from a newbie to an advanced user can take this course.

Enroll now: Excel 2013: Mastering Vlookup and Hlookup Functions

Summary

Title: Excel 2013: Mastering Vlookup and Hlookup Functions

Price: $19.99

Average Rating: 4.5

Number of Lectures: 7

Number of Published Lectures: 7

Number of Curriculum Items: 7

Number of Published Curriculum Objects: 7

Original Price: £19.99

Quality Status: approved

Status: Live

What You Will Learn

Understand how data lookups work in Excel
Use VLookup and HLookup Functions easily
Adopt a Structured Approach when using the lookup functions

Who Should Attend

Anybody from a newbie to an advanced user can take this course

Target Audiences

Anybody from a newbie to an advanced user can take this course

Looking up data in Excel 2013 is a fun thing. Yet many students find it difficult to search for data in Excel due to arcane explanations provided in help files and tutorials.

"Looking up", simply means to search a particular value from a spreadsheet or workbook against a particular value that we know before hand. It can be likened to looking up a word in a dictionary, or a record in a database.

Excel makes it easy to search for values, both in rows and columns. While there are advanced functions also that enable Excel users to search for data "database-style", the HLookup and VLookup functions are their simpler-yet-powerful siblings. Simpler? Yeah! Because, why should you use a cannon to shoot a fly?

After this course, whether you want to calculate grades in Gradebooks, design Directories or draw-up Invoices, you'll be able to do it on your own, and in a jiffy. The course spans about 40 mins, with live examples, practice workbooks to follow along, and chalk board style logic-behind teaching.

So….hit it!

Course Curriculum

Chapter 1: Understanding VLookup and HLookup

Lecture 1: VLookup Syntax & Uses – The Chalk Board

Lecture 2: VLookup Live Example – Exact Match

Lecture 3: VLookup Live Example – Approximate Match

Lecture 4: HLookup – Syntax and Live Example

Chapter 2: Structured Approach for Using the Lookup Functions

Lecture 1: Using Named Ranges for Lookup Functions

Lecture 2: Restricting Input in Lookup Fields

Lecture 3: Robust Syntax and Error Proofing of Lookup Functions

Instructors

Adnan Ejaz
Telecommunications Engineer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 1 votes
5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu