Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2013: Mastering Vlookup and Hlookup Functions to your Wishlist.

Add to Wishlist

Excel 2013: Mastering Vlookup and Hlookup Functions

Master data lookups in Excel 2013 using the VLookup and HLookup functions. Will help newbies and advanced users, alike.
4.8 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
19 students enrolled
Created by Adnan Ejaz
Last updated 2/2015
English
$20
30-Day Money-Back Guarantee
Includes:
  • 43 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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!

Who is the target audience?
  • Anybody from a newbie to an advanced user can take this course
Students Who Viewed This Course Also Viewed
What Will I Learn?
Understand how data lookups work in Excel
Use VLookup and HLookup Functions easily
Adopt a Structured Approach when using the lookup functions
View Curriculum
Requirements
  • Students will only need to have a very basic understanding of how rows and columns are referenced in Excel
Curriculum For This Course
Expand All 7 Lectures Collapse All 7 Lectures 42:40
+
Understanding VLookup and HLookup
4 Lectures 21:41


VLookup Live Example - Approximate Match
05:30

HLookup - Syntax and Live Example
05:03
+
Structured Approach for Using the Lookup Functions
3 Lectures 20:59
Using Named Ranges for Lookup Functions
07:44

Restricting Input in Lookup Fields
06:29

Robust Syntax and Error Proofing of Lookup Functions
06:46
About the Instructor
4.5 Average rating
12 Reviews
317 Students
4 Courses
Telecommunications Engineer

I am a telecoms engineer with major in Software and Office Automation. I have a knack of teaching difficult subjects in the most intuitive manner, or so I've been told. I have ventured into some online training courses that I have prepared on subjects of common interest between students and professionals.

I am a Microsoft Office aficionado. Word, Excel, Powerpoint, Visio etc. are my forte. I have designed many macros in VBA for automation too.

I am both a developer and designer. I have programming experience for desktop as well as the web. Vb.net, asp.net, jquery, css and html have all been my companions through out my development years. Lately, I have developed some websites in wordpress/php as well. As a designer; Photoshop, InDesign, Fireworks, Flash etc. have been my tools of the trade.

I have a firm grasp of the English language and am adept in both the spoken and written formats. I have used various software and computing tools to make my online courses graphically rich and intuitive. I hope you'll benefit from them.

Report Abuse