Excel: VLOOKUP and XLOOKUP for Beginners

Focused View

Jess Stratton

24:31

0 View

01 - Introduction

01 - Find data quickly in Excel.mp4

00:44

02 - What can you do with XLOOKUP in Excel.mp4

02:58

02 - 1. Using Lookup Functions

01 - Creating a simple XLOOKUP.mp4

08:06

02 - Creating a simple VLOOKUP.mp4

04:44

03 - Handling errors with the @IFERROR function.mp4

03:13

04 - Use dropdown lists and Excel tables for more error-proofing.mp4

04:16

03 - Conclusion

01 - Expand your Excel function and formula skills.mp4

00:30

Description

Many Excel users hear “VLOOKUP” and envision a complicated function reserved only for power users. Not so! VLOOKUP—and XLOOKUP, the newer version for 365 subscribers—are among Excel’s most powerful functions, yet you can master them with a few simple steps. In this mini-course, Jess Stratton walks you step-by-step through creating a simple lookup in Excel using both VLOOKUP and XLOOKUP, then shows you how to error-proof your formulas. Supercharge your Excel skills and save time with these powerful lookup functions.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Modeling

Jess Stratton

Instructor's Courses

I am an instructor with LinkedIn Learning - With over 300 hours of instructional content on Lynda.com, my courses are specialized for businesses, home office, social media, and personal use focusing on Google Apps, Microsoft Office, home tech, and productivity/mobile apps. My writings have been in computer textbooks, and I have several published articles in industry magazines and major websites including Lifehacker.org. I'm a frequent speaker at large industry conferences about productivity, web, and Lotus Notes/Domino. I used to own and operate a successful brick-and-mortar boutique style computer learning facility in downtown shopping district. I LOVE my job. I get to help people be the very best at their own jobs.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.