VLOOKUP and SUMIFS Excel Functions

Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser VLOOKUP and SUMIFS Excel Functions November   10 3 pm - 4:40 pm ET Presenter: Jeff Lenning, CPA, 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 Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   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." Learn More Register Today About The Presenter   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. Learn More Register Today All-Access Membership   ● 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 Learn More Upcoming Webinars Master Vendor Files Best Practices November 3 at 1 pm ET Learn More CPA's Guide to U.S. Taxation of Cross-Border Transactions November 4 at 1 pm ET Learn More Real-Time Reporting Using the 3 Rs November 8 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.

Real-Time Reporting Using the 3 Rs

Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Real-Time Reporting Using the 3 Rs November   8 1 pm - 2:40 pm ET Presenter: Ron Rael, CEO and Founder of the High Road™ Institute 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 Learn More Register Today Course Description   Managers want information at their fingertips that is operational and risk-focused, not accounting-based. In this webinar, you'll learn about the 3 ingredients necessary to create real time management reports that always deliver insightful information instead of data. Upon completion of this course, you'll be able to: Name and explain the three R's of reporting to management Develop a simple cause and effect approach to selecting metrics Use the Howard Hughes Test to determine your most important Key Performance Indicators Use a survey to define the metrics managers want to see Apply your employer's global strategy to develop a scorecard Learn More Register Today About The Presenter   Ron Rael, CPA, is the CEO and founder of the High Road™ Institute. Mr. Rael is a leadership consultant, professional facilitator and coach to experienced leadership teams and emerging leaders. Mr. Rael frequently presents on leadership and Controllership/CFO topics. Mr. Rael's 40+ years of business experience comes from working in two fortune 500 companies, as well as from leading accounting teams in numerous closely held industry leaders. Learn More Register Today All-Access Membership   ● 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 Learn More Upcoming Webinars Eggshell Audits: Keeping Your Client Out of Jail October 28 at 1 pm ET Learn More Excel Chart Nuances November 2 at 1 pm ET Learn More Asset Sale vs. Stock Sale: Structuring a Business Sale Transaction with Optimal Tax Results November 2 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.