Self Study: Two Critical Excel Functions: VLOOKUP and SUMIFS

Overview

This course is available until April 30, 2025.

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.

Notice

Online Self-Study