Microsoft Excel is an invaluable and indispensable tool for every office employee, in almost every industry. One of the most important formulas in Excel are the Look-up formulas, used to see individual entries in large data sheets.
Look-up formulas are a useful tool to compare data entries and maintain accuracy in records, especially in large data sheets and are one of the best ways to improve the integrity of Excel spreadsheets. Proper use of Look-up functions can reclaim a part of your day, as you get better at finding the information you need from vast repositories of data.
Excel expert David H. Ringstrom, CPA, introduces the VLOOKUP function, arguably one of the most useful functions in Excel, and goes beyond its basic use. David explains what can go wrong with VLOOKUP, how to future-proof the function and explores alternatives such as MATCH/INDEX, SUMIF, SUMIFS, and SUMPRODUCT. With this audio, you'll be able to reference data from anywhere in an Excel workbook with ease.
David will teach primarily from Excel 2010, and will demonstrate new features in Excel 2013 when required, as well as disclose any differences with Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience.
This webinar will also help you to:
Who should attend
Practitioners who rely on look-up functions within their spreadsheets, such as:
David Ringstrom CPA
David is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Excel, and written dozens of freelance articles about spreadsheets. David\'s webinars receive rave reviews, and attendees particularly lik... More info