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!
Accounting Advisors, Inc.
|Advance Preparation Needed||none|
|Delivery Method||Group-Internet Based|
|Recommended CPE Credit||1 credit per 50-minute session*|
|Registration Instructions||register online|
|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.