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.
Harassment, Bullying, Gossip, Confrontational and Disruptiv…
Leadership: Strategic Planning and Decision Making
4-Hour Virtual Seminar on Transformational Leadership - The…
Workplace Investigations 101: How to Conduct your Investiga…
Copilot and HR: An Introduction for HR Professionals
Negotiating Skills For Professional Results - Winning Strat…
2-Hour Virtual Seminar on the 6 Most Common Problems in FDA…
Managing Complex Projects - Project Management
Managing Toxic Employees: Strategies For Leaders To Effecti…
Excel Power Skills: Master Functions, Formulas, and Macros …
Ultimate Persuasion Strategies! - Secret Influence Tools & …
Excel - Pivot Tables - The Key To Modern Data Analysis and …
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
Do's and Don'ts of Giving Effective Feedback for Performanc…
Using High-Performance Coaching for Managers to Address Per…
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Understanding Artificial Intelligence (AI) & using Chat GPT
Do's and Don'ts of Documenting Employee Behaviour, Performa…
Creating Your 2025 Marketing Strategy
Enhance Your Confidence and Leadership Presence
Trust in Leadership: Building and Maintaining Trust as a Le…
Effective Communication Skills It’s Not What You Say, But H…
2026 Handbook Overhaul: Navigating Critical Updates! Does t…
From Concept to Creation: Strategies for Cultivating Workpl…
Mastering Performance Management: Strategies for Continuous…
2025 EEOC & Employers: Investigating Claims of Harassment …
Project Management for administrative professionals
The Importance of the first 5 seconds when presenting
How to Reduce Human Error in a GMP Manufacturing Floor
Trump’s Executive Orders on DEI and Disparate Impact, and t…
How Accountants Can Use Chat GPT Effectively
Changing Behavior: Why Rewards and Punishments Often Aren't…
Pivot tables beginner to advanced + 20 advanced Pivot table…
The OBBBA Era & Beyond: Your 2025 Playbook for Compliance a…
Managing Toxic & Other Employees Who Have Attitude Issues
ChatGPT Unlocked: A Beginner’s Guide to AI and ChatGPT
Employee Handbooks: 2025 Critical Issues