Instructor for this course
more

Hello and welcome Excel fans everywhere to our heavyweight event! 

In one corner, with an impressive 20-year career, introducing the reigning champion of lookup functions, VLOOKUP. In the other corner, quickly gaining popularity with users, a recently introduced powerhouse, SUMIFS. Both functions have their unique ins and outs and situations in which you would prefer one over the other.

In this course, we’ll witness an epic battle between these two Excel heavyweights and watch these rivals go head-to-head using real-world examples and a full explanation of each. Who will win? Join us and find out…

Learning Objectives

  • Explore the arguments of the VLOOKUP function
  • Identify the SUMIFS function arguments
  • Recognize the differences between these two functions

 

43 Reviews (113 ratings)Reviews

4
Member's Profile
The course video itself was fine A++. My critique is the quiz. The test questions were poorly worded. For example, when it asks about "performing a match", I wasn't sure at what point of the logic. VLOOKUP looks for an answer in the leftmost column, then spits out the number to the right. I interpreted this question as "after it has performed its match where does it go from there"? I was annoyed that I knew the answer, but I got it wrong because of the wording of the question.
3
Anonymous Author
This course is geared towards beginner level excel users and provides a very details explanation of these two functions for users that are not familiar with them. Examples were a little long but were effective in showing how to use these functions, their differences, and limitations. Effective course, but material could have been covered in a shorter time period.
4
Member's Profile
Very clever way to show comparison of the 2 and gave great real-world examples of when you would use each. Going over examples a few times was a bit repetitive, but for beginners would be necessary. Overall Great
5
Member's Profile
Awesome course for learning the differences and similarities between these two formulas. Had some familiarity with VLOOKUP but learned a little more and definitely learned a lot about SUMIFS.
5
Anonymous Author
By repeating all the exercises and formulas, it is now easier to remember the formulas. Practical summary of how to remember the formula versus the "code" is helpful. Clear and concise.
5
Member's Profile
I loved this course. I didn't realize how to use the SUMIFS function and I will definitely use it now. I need to practice right away before I forget how to use it!
5
Member's Profile
The instructor explains the use of both the functions step by step and compares its benefits and shortfalls. This course is useful for advanced Excel users too.
5
Anonymous Author
Typically I've resorted to using VLOOKUP however, after completing this course, can see the value in substituting SUMIFS or using a combination of the two.
5
Anonymous Author
A helpful and informative course on V-look up and SUMIFS functions. A good precursor to have an in depth knowledge and mastering functional excell skills.
4
Anonymous Author
First time using SUMIFS, liked the comparison between both functions. I can now use either to make my workbooks present information better and save time!
5
Member's Profile
Presenter was very easy to listen to, kept the material moving at a good pace to keep interest, and used very relevant real world examples.
5
Member's Profile
liked the presentation, but there should be a link to the excel spreadsheets so that we can follow along and practice at the same time.
5
Anonymous Author
I have always been worried about the VLOOKUP function and now I feel very comfortable with it. Thank you for a great class!
5
Member's Profile
Fun and informative way to present the practical uses for two related functions. Glad he added the way to use together.
5
Member's Profile
Knowing the differences between SUMIFS and VLOOKUP will be very helpful. Each have their strengths and limitations.
5
Member's Profile
The presenter was engaging and enthusiastic.
5
Member's Profile
Course was presented in an effective manner with the right amount of repetition, pace and context. Well done.
5
Member's Profile
Excellent instructor. Entertaining and very informative. Increase in understanding of sumifs.
5
Member's Profile
This course extended my understanding of both functions. Jeff made it fun and interesting.
5
Anonymous Author
This was the first course I tried and it was very helpful and clear. I like Illumeo!
5
Member's Profile
The instructor kept my attention and did a great job of explaining the funcitons
5
Member's Profile
sumif is a very complex formula but not as vlookup are. loved this self study!
5
Member's Profile
Superior instruction! Great teaching style and easy to follow and understand.
5
Member's Profile
This was the best explanation of VLOOKUP and SUMIFS that I have ever heard.
5
Member's Profile
Love how excited instructor was! Made it easy to stay completely engaged.
4
Anonymous Author
The instructor made it interesting and was engaged throughout.
5
Member's Profile
The Instructor is excellent and carries the course with ease.
5
Member's Profile
clarity of concept explained followed by practice examples
5
Member's Profile
Really interesting deep dive on a cool Excel topic.
4
Member's Profile
Went over good material and all types of examples.
5
Member's Profile
The teacher had great energy and enthusiasm!
5
Anonymous Author
Excellent and impressive presenter!
5
Member's Profile
Another useful course by Jeff.
5
Member's Profile
good course on hard subject
5
Member's Profile
New learning. Good session
5
Member's Profile
Amazing course! Loved it.
4
Member's Profile
Interesting presentation
5
Anonymous Author
Great course. Thanks!
3
Member's Profile
Excellent comparison.
5
Anonymous Author
Well presented.
5
Member's Profile
Good job Jeff.
5
Anonymous Author
Great lesson!
5
Anonymous Author
Nice

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course. 

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 ext. 106, or send an e-mail to .

2 QuestionsCourse Questions and Answers

Member's Profile

Great course!

One question = Isn't the last final exam answer incorrect? I thought VLOOKUP would only find the first value, not the sum of all values, so I picked the second answer, but the course says that the first answer was correct.

Question:

If the lookup value is found on multiple rows in the lookup range, what does the function return?

Response:

Should have chosen
Both SUMIFS and VLOOKUP return the sum of all matching rows

Wrong
VLOOKUP returns the related value of the first matching row, and SUMIFS returns the sum of all matching rows

Member's Profile

Neal...hmmm...thanks for the heads up. The correct answer is "VLOOKUP returns the related value of the first matching row, and SUMIFS returns the sum of all matching rows." I'll have to investigate the exam in this LMS. Thanks for letting me know!
Thanks
Jeff

Course Syllabus
INTRODUCTION AND OVERVIEW
  00:36Introduction to Battle of Two Excel Heavyweights: VLOOKUP vs SUMIFS
  14:51VLOOKUP
  7:58SUMIFS
  11:00Competition
  12:37Competition (Continued)
  2:09Conclusion
CONTINUOUS PLAY
  49.10VLOOKUP vs. SUMIFS: The Battle of Two Excel Heavyweights
SUPPORTING MATERIALS
  PDFVLOOKUP vs. SUMIFS: The Battle of Two Excel Heavyweights Glossary/Index
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM