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 (2 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.
16 students enrolled
$20
Take This Course
  • Lectures 7
  • Length 43 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course 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!

What are the requirements?

  • Students will only need to have a very basic understanding of how rows and columns are referenced in Excel

What am I going to get from this course?

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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Understanding VLookup and HLookup
VLookup Syntax & Uses - The Chalk Board
Preview
04:27
VLookup Live Example - Exact Match
Preview
06:41
VLookup Live Example - Approximate Match
05:30
HLookup - Syntax and Live Example
05:03
Section 2: Structured Approach for Using the Lookup Functions
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Adnan Ejaz, 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.

Ready to start learning?
Take This Course