Live Educational Webinar
Excel Efficiency: VLOOKUP
Price: FREE
May. 23, 2017 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
VLOOKUP is one of Excel’s most useful functions. This course provides an introduction to the VLOOKUP function as well as practical tips for how to use this function to improve the integrity of your spreadsheets, streamline productivity, and decrease accounting errors. We cover the nuances of VLOOKUP, how to counteract missing data with the IFERROR and IFNA functions, and ways to turbo-charge VLOOKUP by incorporating the MATCH function.
This course enables you to:
This course enables you to:
- Improve the integrity of spreadsheets with Excel's VLOOKUP function
- Recognize what causes look-up errors, and see how to overcome such situations
- Understand the new IFNA function available to Excel 2013 users
- Uncover the limitations of VLOOKUP, along with alternatives
- Perform dual lookups across columns and down rows to cross-reference the data you need
Learning Objectives
After attending this event you will be able to:
Identify situations where VLOOKUP may return an error or omit desired data
Improve the integrity of VLOOKUP by way of the MATCH function
Make critical distnctions in your data, such as numbers stored as text
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: Khoa Tran
Operations Manager, Illumeo
Khoa is in charge of live event operations at Illumeo and has led the preparation and execution of hundreds of live events on various finance, accounting and related topics across the Office of the CFO. You could say his job is a lot like learning finance and accounting for a living. Khoa is primarily responsible for ensuring great content, delivery, and learning for each of Illumeo's webinars and live events.
