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, SUMIFS, SUMPRODUCT, IFNA, MAXIFS, and OFFSET functions.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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 H. Ringstrom
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 and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
Female to Female Hostility @Workplace: All you Need to Know
The Importance of the first 5 seconds when presenting
How to Manage the Legal Landmine of the FMLA, ADA and Worke…
Managing Difficult Employee Conversations
How to Write Effective Audit Observations: The Principles f…
Managing Toxic & Other Employees Who Have Attitude Issues
2025 EEOC & Employers: Investigating Claims of Harassment …
Leadership: Strategic Planning and Decision Making
FDA Proposes Framework to Advance Credibility of AI Models
Reduce Stress in the Workplace: Effective Ways to Handle Co…
ChatGPT and Project Management: Leveraging AI for Project M…
Leverage AI-Powered Tools for Talent Acquisition: Best Prac…
6-Hour Virtual Seminar on Learning the Highlights of Excel …
With Mandatory Paid Leave Gaining Ground Is It Time To Do A…
Form W-9 Compliance: TIN Verification, B Notices, and Avoid…
How to Give Corrective Feedback: The CARE Model - Eliminati…
Tattoos, hijabs, piercings, and pink hair: The challenges …
Stress, Change And Team Resilience Through Humor: An Intera…
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
AML Regulatory Insight for Q1 2025: Implementing recent cha…
How to Write Right for Better Business Communication
Gossip-Free: Leadership Techniques to Quell Office Chatter
Improving Employee Engagement & Retention Through Stay Inte…
Transforming Anger And Conflict Into Collaborative Problem …