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.
| 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.
