Excel Lookups: VLOOKUP vs. SUMIFS (ACVS)


'
Discussion Leader
Jeff Lenning

No Future Events exist.
{{ successMessage }}
{{ errorMessage }}

Excel Lookups: VLOOKUP vs. SUMIFS (ACVS)

Customer Rating

Field of Study

Technology

Level

Basic

Credits

1

Qualifies For

CPE

Overview

Excel users often use VLOOKUP out of habit, even when there may be a better option. In this webinar, we’ll compare VLOOKUP to SUMIFS so that you are comfortable knowing when to use them in your workbooks.

Major Topics

  • VLOOKUP function arguments and applications
  • SUMIFS function arguments and applications
  • Comparing VLOOKUP to SUMIFS and identifying 5 key differences

Learning Objectives

  • Recall the arguments of VLOOKUP
  • State the SUMIFS function arguments
  • Identify the key differences between these functions

Designed For

Groups learning about computer software and applications

Prerequisite

None

Advanced Preparation

None


'
Discussion Leader
Jeff Lenning

No Future Events exist.
{{ successMessage }}
{{ errorMessage }}