Enhance your skills with Learn Excel Loop Function Course offered by Linkedin. Get the knowledge of using XLOOKUP, VLOOKUP and HLOOKUP functions. Get the relevant details below!
About Linkedin Learning
Learn business, creative, and technology skills to achieve your personal and professional goals through various professional skills-building courses offered by Linkedin.
Course Includes
- 1 project file
- 4 chapter quizzes
- Access on tablet and phone
- Certificate of completion
Course Description
Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets.
In this course, Excel expert Dennis Taylor demystifies some of the most significant lookup functions.
- Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility.
- Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function.
- Discover how to restructure the lists being searched to ensure that you’re using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER.
- Along the way, Dennis shares practical examples that help you grasp how to implement these functions in your workflow.
Course Completion Certificate
- Showcase on your LinkedIn profile under the “Licenses and Certificates” section
- Download or print it out as PDF to share with others
- Share an image online to demonstrate your skill
How to Join?
Interested Learners can join this course by this link.
Duration
60 minutes
Rating
This course is rated 4.5/5 by 15 Lakh+ learners.
