High Impact Excel: VLOOKUP Edition

View the Webinar

Follow this link to register or access the recording. After this seminar has passed, the recording will still be available.

CPE CREDIT WILL BE AVAILABLE TO LIVE ATTENDEES ONLY.

Event Date: February 27, 2014

In this session Excel expert David Ringstrom introduces 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

Download these files to accompany this session:
High Impact Excel  VLOOKUP Edition-Slides.pdf
High Impact Excel  VLOOKUP Edition-Handouts.pdf
High Impact Excel  VLOOKUP Edition-All Excel Versions.xls


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 Levelintermediate
Prerequisitesnone
Advance Preparation Needednone
Delivery MethodGroup-Internet Based
Recommended CPE Credit1 credit per 50-minute session*
Registration Instructionsregister online
Costfree
Complaint Resolutionpublisher@accountingweb.com
Refund policy/Cancellation policyDue 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.