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 🙂

There are six live sessions plus an on-demand version for those with scheduling conflicts.

FREE LIVE SESSIONS (1 CPE)
Register for one of the free live sessions:

  • Aug 16 @ 1p CT
  • Aug 19 @ 2p CT
  • Aug 20 @ 2p CT
  • Aug 21 @ 10a CT
  • Aug 21 @ 1p CT
  • Aug 22 @ 10a CT

 

  • The registration page has a time zone converter to make it easy to see these in your local time.
  • Jeff Lenning CPA presents these sessions live, in real-time and you can submit questions.
  • Webinar registration includes a complimentary subscription to the Excel University blog
  • Live webinar earns 1 CPE credit if you need it

FREE ON-DEMAND VERSION (No CPE)

If you have scheduling conflicts with the live dates, please watch the free 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.