Content Provider
Excel u logo
Additional Materials
Webinar Technical FAQs
Excelheavyweights excelu

EXCEL HEAVYWEIGHTS: VLOOKUP VS SUMIFS

Cost Free
Presentation Length 1.0 hour

Recorded DateAugust 23, 2019
CPE:Not available
(archived webinars do not offer CPE credits)
Course LevelBasic
Series: Excel
Course Description

Ladies and gentlemen, welcome to the main event. In this corner, with an impressive 30-year career, introducing the reigning champion of Excel lookup functions, VLOOKUP. In the opposite corner, quickly gaining popularity with Excel users, the challenger, SUMIFS. In this webinar, we’ll witness an epic battle between these two Excel heavyweights. Who will win? Join us and find out….ROUND 1…FIGHT!

Note: your admission to this event also includes a complimentary subscription to the Excel University blog!

Learning Objectives

  • Recall the arguments of the VLOOKUP function.

  • Identify the SUMIFS function arguments.

  • State the differences between these two functions.

Not logged
Testimonials
Profile img default

Tracy Stone (Greggs & Reid CPAs, PC)

"I chose the SUMIF function to be the winner and thought I was right until the 4th round. I absolutely love how all the functions work in Excel and to find out that they work together as well is amazing. Thanks!"
Profile img default

thao Le (thao Le)

"The presenter was very passionate and excited about Excel. He took something that was difficult to understand at first and simplified it."
Profile img default

David Korn (David Korn CPA)

"Reinforcement of the material by demonstrating how to use formulas made this one of the best online seminars I have attended in a while."
Profile img default

Kat Chidester (March Westin)

"GREAT webinar. The presenter was enthusiastic and upbeat. Information was presented well and at an appropriate knowledge level."
Profile img default

Brad Hopper (Self Employed)

"Fantastic instructor. Never felt left behind, spoke clearly, repeated any difficult areas, great on-screen tools/examples."
Profile img default

Thomas Stoelk (self employed)

"High energy level learning experience that provides a fun and fast learning experience for Excel. Highly recommend!"
Profile img default

Margie Fabro (M Fabro Tax & Accounting Service)

"I love the webinar, great presentation! Definitely practice more on VLOOKUP and SUMMIFS for work efficiencies."
Profile img default

Shelly Buck (Stone, Avant & Daniels)

"Jeff is a fantastic speaker/presenter! He makes Excel look so easy. Thank you for your wealth of knowledge!"
Show more testimonials
PLEASE NOTE: ARCHIVED WEBINARS DO NOT QUALIFY FOR CPE
Linkedin

Jeff Lenning, CPA, CITP

Excel University
Author of Excel University
jeff@excelu.com
(949) 200-7688

Excel u logo

Award-winning instructor Jeff Lenning has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient.

User-added image

About Our Presenter

Excel u logo
If you could learn Excel simply and easily at your pace and could learn the features and functions that are relevant and practical to accounting professionals – would you want to? If you are an accounting professional and have taken Excel classes before, you know the pace can be too fast or too slow, and the content may not be relevant to your work. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way. Become more efficient, streamline processes, and save time with Jeff Lenning’s Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you don’t. The content has been written from scratch integrating everything Jeff knows about Excel training learned over the past decade of providing continuing professional education.