Online Course on Excel: VLOOKUP and XLOOKUP for Beginners by LinkedIn
VLOOKUP and the new and improved XLOOKUP are Excel functions that can look up a value in an Excel table or row and return related data. In a long spreadsheet, you can look up a price based on a part number or a phone number based on a name.
- English
- With Certificate
Tutor Name
LinkedInAbout the Course
LinkedIn is offering an online course on the theme of Excel: VLOOKUP and XLOOKUP for Beginners.
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.
Contents:
- Introduction:
Find data quickly in Excel
What do you do with XLOOKUP in Excel?
Chapter quiz
- Using lookup functions:
Creating simple XLOOKUP
Creating a simple VLOOKUP
Chapter quiz
- Conclusion:
Master more functions and formulas in Excel
Certificate of Completion:
- Showcase on your LinkedIn profile under the "Licenses and Certificates" section
- Download or print out as PDF to share with others
- Share as image online to demonstrate your skill
See more available internships on For9a
See more opportunities in the USavailable on For9a
Taught by
LinkedIn is a business and employment-focused social media platform that works through websites and mobile apps. It was launched on May 5, 2003 by Reid Hoffman and Eric Ly. Since December 2016, LinkedIn has been a wholly owned subsidiary of Microsoft. The platform is primarily used for professional networking and career development, and allows jobseekers to post their CVs and employers to post jobs. From 2015, most of the company's revenue came from selling access to information about its members to recruiters and sales professionals. LinkedIn has more than 1 billion registered members from over 200 countries and territories.
Read more.