Live Educational Webinar
Excel Efficiency: V-Look Up and Beyond
Price: FREE
Sep. 24, 2019 Tuesday
11:00 AM - 12:00 PM (Pacific)
1 Hour
Free Live Webinar
- Free CPE
- Non-sponsored Events mean you never listen to a 3rd party sales pitch – it’s all just great education
- Expert-instructor-led learning with live Q&A
- Based on a great course on Illumeo
David Ringstrom President and CPA, Accounting Advisors Inc
Excel expert David Ringstrom, CPA, explains helpful ways you can improve the integrity of your spreadsheets using Excel’s lookup functions. While many users rely on VLOOKUP to return data from other locations in a worksheet, that’s not always the most efficient approach. In this comprehensive presentation, David reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, SUMIF functions. You'll see why to avoid the LOOKUP function in Excel, and contrast the IFERROR and IFNA error handling functions.
David draws your attention to any differences in various versions of Excel during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
David draws your attention to any differences in various versions of Excel during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Learning Objectives
After attending this event you will be able to:
Apply a variety of lookup functions in order to work more efficiently in Excel.
Recognize why the INDEX and MATCH combination is often superior to VLOOKUP or HLOOKUP.
Apply the SUMIF and SUMIFS functions.
Speakers
David Ringstrom
President and CPA, Accounting Advisors Inc
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 300 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.
