September 24, 2020

RSVP: Learn About the VLOOKUP Function on February 27th

Event Date: February 27, 2014

In this session Excel expert David Ringstrom will introduce beginners to the VLOOKUP function, and then go beyond the basics with a discussion of with the MATCH, CHOOSE, INDEX, SUMIF, SUMIFS, and SUMPRODUCT functions. David will also show you how to:

  • Improve the integrity of VLOOKUP by way of the MATCH function and Table (List in Excel 2003) feature
  • Show three different ways to deal with VLOOKUP returning #N/A
  • Help you avoid common pitfalls that plague users of look-up formulas

David's presentations are fast-paced, so even seasoned Excel users are likely to learn several new tricks and techniques. David will provide detailed handouts and example workbooks for these versions of Excel:

  • Excel 2013
  • Excel 2010
  • Excel 2007
  • Excel 2003

Excel for Mac users will find that the Excel 2003 handouts closely approximate the Excel for Mac interface.

After the webinar, "Ask David Anything" will allow you to get your Excel questions answered by David Ringstrom. The webinar is a jam-packed session and we know lots of people want to get their specific questions answered, so we're setting aside an hour for David to answer your questions. Please note that your attendance of the Q&A session will NOT be eligible for CPE credit, but there will be tons of Excel expertise to be had. We hope you'll join us for the extra session!

Presenter:
David Ringstrom
Owner
Accounting Advisors, Inc.
 
David H. Ringstrom, CPA  is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. He teaches dozens of webinars each year and speaks at conferences on Excel, along with writing freelance articles about spreadsheets that appear internationally. Webinar attendees are often amazed by how much ground David can cover in a short period of time.
Program Level intermediate
Prerequisites none
Advance Preparation Needed none
Delivery Method Group-Internet Based
Recommended CPE Credit 1 credit per 50-minute session*
Registration Instructions register online
Cost free
Complaint Resolution publisher@accountingweb.com
Refund policy/Cancellation policy Due to this program being offered free of charge, there will be no refunds issued

Sift Media is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing 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 submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

* To obtain CPE credit, the live session must be attended.  THE RECORDING DOES NOT QUALIFY FOR CPE CREDIT.

Have something to add to this story? Give us a shout by email, Twitter, or text/call the tipline at 202-505-8885. As always, all tips are anonymous.

Related articles