Excel's VLOOKUP Function
0.0 (0 ratings)
0 students enrolled
Wishlisted Wishlist

# Excel's VLOOKUP Function

This course is an introduction to the VLOOKUP function in Excel, with practical tips for how to best use the function.
New
0.0 (0 ratings)
0 students enrolled
Last updated 8/2017
English
Current price: \$12 Original price: \$50 Discount: 76% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
• 1.5 hours on-demand video
• 4 Articles
• 4 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion

### Training 5 or more people?

What Will I Learn?
• Identify situations where VLOOKUP may return an error or omit desired data.
• Improve the integrity of VLOOKUP by way of the MATCH function.
• Make critical distinctions in your data, such as numbers stored as text.
View Curriculum
Requirements
• Prerequisite: Basic proficiency with Excel
• No advanced preparation is needed for this course.
Description

VLOOKUP is one of Excel’s most useful functions. This course provides an introduction to the VLOOKUP function as well as practical tips for how to use this function to improve the integrity of your spreadsheets, streamline productivity, and decrease accounting errors. We cover the nuances of VLOOKUP, how to counteract missing data with the IFERROR and IFNA functions, and ways to turbo-charge VLOOKUP by incorporating the MATCH function.

This course enables you to:

• Improve the integrity of spreadsheets with Excel's VLOOKUP function.
• Recognize what causes look-up errors, and see how to overcome such situations.
• Understand the new IFNA function available to Excel 2013 users.
• Uncover the limitations of VLOOKUP, along with alternatives.
• Perform dual lookups across columns and down rows to cross-reference the data you need.
Who is the target audience?
• Anyone interested in Excel for business.
• Anyone in Finance accounting or related fields.
Compare to Other Vlookup Courses
Curriculum For This Course
12 Lectures
01:36:35
+
Introduction
8 Lectures 01:36:31
Preview 11:11

Text vs. Numbers
08:48

VLOOKUP Errors
08:12

IFERROR function
07:35

IFNA Function
02:32

Duplicate Data - MATCH Function
07:20

02:39

Excel Efficiency: VLOOKUP Continuous Play
48:14
+
Supporting Materials
4 Lectures 00:03
Excel Efficiency VLOOKUP-Slides
00:00

Excel Efficiency: VLOOKUP Glossary/Index
00:01

Excel Efficiency VLOOKUP-Excel 2003
00:01

Excel Efficiency VLOOKUP-Excel 2007-2013
00:01
+
Review and Test
0 Lectures 00:00
Review Questions
3 questions

FINAL EXAM
5 questions
 4.4 Average rating 326 Reviews 1,402 Students 242 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

 4.3 Average rating 15 Reviews 94 Students 14 Courses

David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at conferences. He is the co-author of Idiot's Guides: Introductory Accounting, and has served as the technical editor for over 30 books on accounting software. Some of his hundreds of freelance articles on spreadsheets have been published internationally.

#### Experience

President : Accounting Advisors, Inc. - [1991-12 to Current]
David offers spreadsheet, database, and accounting software consulting services nationwide. He focuses on streamlining complex business processes via a combination of training, tools, and custom programming.

#### Education

Bachelor of Business Administration, Accounting : J. Mack Robinson College of Business (at Georgia State University )