To Access This Course:
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
35 Reviews (75 ratings)Reviews
Anonymous
(Sr. Mgr - Credit Card Accounting)
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.
Rod Streets
(Vice President - Finance at YESCO LLC)
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.
Radhesh Pradhan
(Accounting Manager at DGN Technologies Inc)
Amazing course! Loved it.
Andrew Jurado
(Program Manager at Willdan Energy Solutions)
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.
Nate Sives, CIA, CAMS
(Staff Auditor II at FNCB Bank)
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
Dominick Pariano
(Senior Auditor at PolyOne)
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.
Anonymous
(Manager, Conservatorship Operations)
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.
Teresa Spector
(Not Provided at Elsevier)
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!
Anonymous
(Revenue Analyst)
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.
Anonymous
(Accounting Manager)
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.
Anonymous
(Operations Controller)
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!
Erika Phillips
(Controller at Fallbrook Technologies)
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.
Anonymous
(Accounting Solutions Senior)
I have always been worried about the VLOOKUP function and now I feel very comfortable with it. Thank you for a great class!
Samuel Naccarato
(Associate Manager at Yelp Inc)
Knowing the differences between SUMIFS and VLOOKUP will be very helpful. Each have their strengths and limitations.
Anonymous
(Controller)
This was the first course I tried and it was very helpful and clear. I like Illumeo!
Bette Shepherd
(CFO at D&S Green Services)
The instructor kept my attention and did a great job of explaining the funcitons
Ravi Patel
(Tax Accountant at Patel)
sumif is a very complex formula but not as vlookup are. loved this self study!
Gary Hall
( at Self employed)
Superior instruction! Great teaching style and easy to follow and understand.
Deborah Duncan
(Accounting Manager at Intermedix)
This was the best explanation of VLOOKUP and SUMIFS that I have ever heard.
Megan Tiegs
(Consultant at Salo LLC)
Love how excited instructor was! Made it easy to stay completely engaged.
Anonymous
(CFO)
The instructor made it interesting and was engaged throughout.
Omar R. Graham CPA, MBA
(Financial Officer at University of Toronto)
The Instructor is excellent and carries the course with ease.
Rajeev Sahni
(Director - Capital (RWA) at UBS)
clarity of concept explained followed by practice examples
Simon Adell
(Chief Financial Officer at Undisclosed)
Really interesting deep dive on a cool Excel topic.
Chantell Haines
(Accountant at Sustainable Brands)
The teacher had great energy and enthusiasm!
Anonymous
(Accountant)
Excellent and impressive presenter!
Charles Elwis
(None at none)
Another useful course by Jeff.
brian bleifeld
(Partner at Bleifeld CPA LLC)
good course on hard subject
Ramakrishna Nalluri
(Senior Financial Analyst at Morneau Shepell Inc)
New learning. Good session
Jeffrey Miller
(Financial Analyst at LNCE)
Interesting presentation
scott steiner
(attorney cpa at slo, pllc)
Excellent comparison.
Anonymous
(None)
Well presented.
Ann Kennedy
(CFO at EsmokerCanada)
Good job Jeff.
Anonymous
(Staff Accountant)
Great lesson!
Anonymous
(Senior Internal Auditor)
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 .
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
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