فرصة

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

LinkedIn
Online Course on Excel: VLOOKUP and XLOOKUP for Beginners by LinkedIn

About 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

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.