VLOOKUP and SUMIFS Excel Functions | | | | | | | November | | 10 | 3 pm - 4:40 pm ET | | | | | | | | | 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
Course Reviews from Past Attendees
100% of attendees said they would recommend this course to others. "Appreciated the enthusiasm with which the speaker delivered the presentation." "Excellent hands-on examples with repeated reviews." "Great explanations and information." | | | | | | | 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 an 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 850 on-demand courses | | | | | | |
|
|
No comments:
Post a Comment