Two Critical Excel Functions: VLOOKUP and SUMIFS
Available Until
Virtual
2.00 Credits
Member Price $69.00
Non-Member Price $89.00
Overview
The VLOOKUP function has long been the reigning champion of Excel’s lookup functions. But the recently introduced SUMIFS function is quite powerful. So which function should we use to perform our lookup tasks? In this session, we’ll dig into this question and see when and how these functions can be used. Course is presented in Excel for Windows. Note: Certain items presented may not be available in all Excel versions, including Excel for Mac, iPad or web. The webcast was originally broadcast on May 3, 2016. Note: There is a minimum passing rate of 70% for this course.
Highlights
• VLOOKUP function • SUMIFS function • VLOOKUP and SUMIFS comparison
Designed For
Accountants using Excel for Windows.
Objectives
• Identify the differences between VLOOKUP and SUMIFS. • Recall the arguments for the VLOOKUP and SUMIFS functions. • Recognize the function that can return the sum of all matching values in a range.
Non-Member Price $89.00
Member Price $69.00