Attend upcoming webinar and earn continuing education credits. VLOOKUP and SUMIFS Excel Functions | | | | | | | October | | 22 | 3 pm - 4:40 pm ET | | Presenter: Jeff Lenning, founder of Click Consulting Inc. | | Credits: CPE (Credit Details) | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | In this practical webinar, you'll learn about two critical Excel functions, VLOOKUP and SUMIFS. VLOOKUP is the traditional and perhaps the most popular Excel lookup function, but SUMIFS, a relatively new function, is quickly gaining traction among Excel users. Upon successful completion of this course, you will be able to: - Identify the features of the VLOOKUP and SUMIFS Excel functions
- Utilize the VLOOKUP function to return a related value
- List the four arguments of the VLOOKUP function
- Utilize the SUMIFS function to perform conditional summing
- Recognize the arguments of the SUMIFS function
- Compare and contrast VLOOKUP and SUMIFS
| | | | | | | Jeff Lenning, CPA, is the author of Excel University and founder of Click Consulting Inc., a technology consulting firm. Before that, Mr. Lenning was a senior financial analyst at Gateway computers and accounting manager at Interpore Cross International. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses | | | | | |
No comments:
Post a Comment