Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Two Critical Excel Functions: VLOOKUP and SUMIFS 4173133B
View Registrations Tell a Friend About This EventTell a Friend
 

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, 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.

11/10/2017
When: 9:30 AM to 11:30 AM
Where: Webinar/Webcast
United States
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-466-10545


Online registration is closed.
« Go to Upcoming Event List  

Curriculums:   Computers and Technology

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

Description

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, 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.

Materials are provided as an ebook.



Major Subjects

  • VLOOKUP function
  • SUMIFS function
  • VLOOKUP and SUMIFS comparison

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.

Level:  Overview

Designed For

Accountants using Excel for Windows.

Advanced Prep:

None.

Prerequisite

None.

Membership Management Software Powered by YourMembership  ::  Legal