Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

XLOOKUP Function – The Successor to VLOOKUP and Its Much Better

In this class, you will learn the new XLOOKUP function of Excel. This awesome new function is the successor to VLOOKUP and HLOOKUP (you can now forget about ...
5.0
☆☆☆☆☆ 5.0/5
(2 reviews)
126 students
Created by
Alan Murray

8.8

Classbaze Grade®

7.5

Freshness

9.5

Popularity

8.9

Material

Detailed Analysis »

Go to course »
Platform: Skillshare
Price: check current price
Video: 35m
Language: English
Next start: On Demand

Best Business Analytics classes:

Skillshare_logo_2020
Best Business Analytics classes on Skillshare »
Coursera Logo
Best Business Analytics classes on Coursera »
Pluralsight Logo
BestBusiness Analytics classes on PluralSight »
Udemy logo
Best Business Analytics classes on Udemy »
linkedin
Best Business Analytics classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

8.8 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

7.5 / 10
This course was last updated on 10/2019.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

9.5 / 10
We analyzed factors such as the rating (5.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

8.9 / 10
Video Score: 7.6 / 10
The course includes 35m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 2 hours 05 minutes of 319 Business Analytics courses on Skillshare.
Detail Score: 9.2 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 10.0 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
0 tests or quizzes.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

In this class, you will learn the new XLOOKUP function of Excel. This awesome new function is the successor to VLOOKUP and HLOOKUP (you can now forget about those functions).

VLOOKUP is the third most commonly used function of Excel (statistics from Microsoft), but it was heavily limited despite how handy it was.

XLOOKUP changes all this. The previous limitations have been fixed and there are also additional features that this function brings.

This class will show you how to use XLOOKUP, why its better than VLOOKUP and also show some advanced uses of the function.

Note: XLOOKUP is currently available only to Office Insiders and will be available publicly very soon. You can sign up to be an Office Insider here.

Download the practise file to follow along with the videos and the project file for the exercises afterwards.

Any questions, please post them and I will get back to you.

I will see you in the class.

What can you learn from this course?

For the class project, you have some exercises recapping on some of the lessons to complete.

Open project-file.xlsx and complete the steps below.

  1. On the Exercise 1 sheet, in cell F2 write an XLOOKUP function to return the stock for ID KL975 (or whatever else is written in cell E2).
  2. On the Exercise 2 sheet, write an XLOOKUP function in cell H2 that returns the last attendance (reverse lookup) for Advanced (cell G2) course in Swindon (cell F2).
  3. On the Exercise 3 sheet, in cell D2 Use an XLOOKUP function with SUMIF to sum the values for Sep (cell D1) and Sheffield (cell C2).

What you need to start the course?

Basic knowledge of Business Analytics is required to start this course, as this is an intermediate level course.

Who is this course is made for?

This course was made for intermediate-level students.

Are there coupons or discounts for XLOOKUP Function - The Successor to VLOOKUP and Its Much Better ? What is the current price?

You can enrol in this course with a Skillshare subscription that costs $8/month, but you start with a FREE 7-day trial. You can also enrol in thousands of courses on a variety of topics with your subscription, including several Business Analytics courses.
The average price is $4.8 of 319 Business Analytics courses. So this course is -100% more expensive than the average Business Analytics course on Skillshare.

Will I be refunded if I'm not satisfied with the XLOOKUP Function - The Successor to VLOOKUP and Its Much Better course?

There is no money-back guarantee with Skillshare, but you can start with a free one-week trial to learn without risk. With the subscription, you can download classes to your tablet or phone using the Skillshare app.

Are there any financial aid for this course?

At the moment we couldn't find any available scholarship forXLOOKUP Function - The Successor to VLOOKUP and Its Much Better, but you can access more than 30 thousand classes for $8/month on Skillshare, including this one!

Who will teach this course? Can I trust Alan Murray?

Alan Murray has created 22 courses that got 2,239 reviews which are generally positive. Alan Murray has taught 23,420 students and received a 4.4 average review out of 2,239 reviews. Depending on the information available, we think that Alan Murray is an instructor that you can trust.

Learn everything about

Alan Murray

IT Trainer, Coffee Lover and Lifelong learner
IT Trainer, Coffee Lover and Lifelong learner
Browse all courses by on Classbaze.
Alan Murray's full profile and courses »
Go to class »

8.8

Classbaze Grade®

7.5

Freshness

9.5

Popularity

8.9

Material

Detailed Analysis »

Go to course »
Platform: Skillshare
Price: check current price
Video: 35m
Language: English
Next start: On Demand

Classbaze recommendations for you

An introductory course in understanding the definition

Business Analytics

An introductory course in understanding the definition, application and techniques involved in Business Analytics.
3.7
★★★★★ 3.7/5
930 students

Other courses by ​Alan Murray

Go to class »