Mastering Lookup Functions in Excel: Seven Powerful Formulas
With Josh Aharonoff
Liked by 594 users
Duration: 1h 15m
Skill level: Intermediate
Released: 6/4/2024
Course details
Dive into the world of Excel lookup functions in this engaging crash course designed to enhance your data handling and data management skills. Join instructor Josh Aharonoff—also known as Your CFO Guy, who has hundreds of thousands of professional online followers on social media—as he offers an in-depth exploration of Excel's most widely used and important lookup functions.
Gain insights into a broad range of topics, such as detailed function syntax and the pros and cons of each function, along with practical exercises that will empower you to leverage your data more effectively. By the end of this course, you’ll be prepared to start using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, the powerful INDEX/MATCH combination, and GETPIVOTDATA. Whether you're just getting started or looking to refine your skills, this course is tailored to help you navigate your datasets with ease and greater confidence.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Ravi Shankar
Ravi Shankar
Senior Talent Advisor | Hiring Data Storage Engineers | India & APAC Region | Hitachi Vantara | Ultra Marathoner
-
Shivam Rai
Shivam Rai
Google certified Data Analyst | Former Sales Executive & Pharmacist | Excel | SQL | Power BI | Python | R | Tableau | Machine Learning
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 8 quizzes
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.