February 28, 2021

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 [email protected]
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.

Latest Accounting Jobs--Apply Now:

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

Job of the Week

Job of the Week: Remote International Tax Manager at WilkinGuttenplan

Featuring a tremendous career opportunity in a rapidly growing practice group of a well-established firm for CPA with 6-8 years of international tax experience. Offering a flexible culture, attractive compensation, and significant career upside with regular one-on-one partner interaction and partner-track potential (if desired). WilkinGuttenplan is committed to work/life balance, a culture of multi-generational collaboration, […]

Job of the Week

Job of the Week: Remote Accountant w/ Sage-Intacct Experience

Going Concern’s Job of the Week features a CPA firm looking for a Remote Accountant with a strong working knowledge of Sage-Intacct and church client experience. If you are interested in this job, we invite you to apply with Accountingfly.  APPLY NOW (updated link) | Accountingfly connects you with virtual accounting jobs with the best […]