Register

Excel University Webinar

VLOOKUP vs SUMIFS

Battle of Excel Heavyweights

Ladies and gentlemen, welcome to the main event. In this corner, with an impressive 30-year career, introducing the champion of Excel lookup functions: VLOOKUP. In the opposite corner, the challenger: SUMIFS.

In this complimentary 1-hour webinar, we’ll talk about these two functions and compare them head-to-head. Plus, we’ll talk about getting certified in Excel. It will be a battle of two Excel heavyweights. Who will win? Join us and find out … ROUND 1 … FIGHT!

Attendees receive a free e-book to keep for reference 🙂

FREE ON-DEMAND VERSION (No CPE)

Please join the on-demand version now through August 29, 2019:

 

  • The on-demand version starts immediately and will start at the beginning.
  • If you don’t have time to watch it now, click the On-Demand Version button above and enter your name and email. The system will email you a link that you can use to launch the webinar anytime between now and August 29, 2019.
  • Although the button on the registration page says “Join Webinar in Progress” it will start at the beginning.
  • Webinar registration includes a complimentary subscription to the Excel University blog
  • On-demand version is not offered for CPE credit

 

Pssst … pass it on!

Know someone who would enjoy this webinar? Please send them a link to this page!


 

Additional Information / Webinar Agenda

In this webinar, I begin by introducing the VLOOKUP function. It is probably the most popular Excel function. Then, I introduce the conditional summing function, SUMIFS. After these brief introductions, I compare them in a 4-round competition. We perform the same task twice, first with VLOOKUP and then with SUMIFS. This allows us to dig into the key differences and understand which one to use in a given situation.

The 4 rounds compare these items:

  1. Multiple matching values
  2. Different data types
  3. Column order
  4. Returning text values

I’ll then talk about getting certified in Excel with the Excel University Graduate Certification program.

Free e-book! Attendees will receive a free e-book to keep as a reference.

Learning Objectives:

  • Recall the arguments of SUMIFS
  • State the VLOOKUP function arguments
  • Identify 4 key differences between VLOOKUP and SUMIFS

Recommended CPE Credit: 1.0
Subject Area: Computer Software & Applications
Course Level: Basic
Instructional Method: Group Internet Based
Prerequisites: None
Advanced Preparation: None

Have you decided to skip the webinar?

If so, no worries … but while you are here, please subscribe to our blog to learn Excel free via email. You’ll be notified of new Excel articles and blog posts.