a Sift Media publication
Sift Media logo

Beyond VLOOKUP: Mastering Advanced Excel Formulas

Thursday, June 25, 1:00 Eastern

Look-up formulas are far superior to manually pointing to specific data elements in a spreadsheet. Many users rely on VLOOKUP to return data from other locations in a worksheet, but is that the most efficient approach? In this session, Excel expert David H. Ringstrom, CPA explores alternatives like MATCH/INDEX, SUMIF, COUNTIF, as well as using SUMPRODUCT to look up values based on multiple criteria. At the end of the presentation you can ask any questions you have of the speaker, even if they're not specifically related to the presentation.

See Full List of Webinar Offerings
Click Here to Purchase

Program Content

Level: intermediate to advanced
Delivery Method: Group Internet-Based
Field of Study: Specialized Knowledge and Applications
  • Learn about the constraints and inefficiences of VLOOKUP
  • See why the MATCH and INDEX combination is often superior to VLOOKUP or HLOOKUP
  • Learn how SUMIF is far easier than VLOOKUP when the goal is to loop up numeric values, and discover it's sister function, COUNTIF
  • Learn how to use the LARGE and SMALL functions to create dynamic top 10 or bottom 10 lists
  • Perform dual lookups, where you look across columns and down rows to cross reference the data you need
Many more tips will be covered, all focused helping you use Excel far more effectively.


Program Prerequisites

  • none

Advance Preparation

  • None, but we'll provide a copy of the handout for you to review prior to the session.

Recommended CPE Credits

  • one hour

Registration Instructions

Refund/Cancellation Policy

Please direct questions, complaints, cancellations, or refund requests to Rob Nance, Publisher, at AccountingWEB at publisher@accountingweb.com or 1.866.688.1678 ext. 16. We will do our best to ensure that every attendee is completely satisfied.

Complaint Resolution Policy

AccountingWEB, Inc. will address any and all complaints, after each event, with dissatisfied customers.


Accountingweb, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site: www.nasbatools.com.