Many Excel users rely on VLOOKUP to pull data from elsewhere in a workbook, but it isn't always the most efficient choice. This 90-minute advanced Excel lookup functions training shows better ways to retrieve data and improve spreadsheet integrity.
You'll see why VLOOKUP stops at the first match, how HLOOKUP handles horizontal matches, and why INDEX and MATCH is often the better option. The session also covers SUMIF, SUMIFS and SUMPRODUCT for summarizing data, OFFSET for referencing accounting periods dynamically, INDIRECT for pulling data from multiple sheets, and IFNA, MINIFS and MAXIFS.
Each technique is demonstrated step by step, along with tips such as restricting date entries and viewing two worksheets at once.
Knowing a range of lookup functions lets you work more efficiently and build spreadsheets that are less prone to errors. You'll see each technique explained with numbered steps and then shown in Excel.
It suits CPAs and accountants, CFOs, controllers, bankers, financial planners, consultants, business analysts, bookkeepers and other Excel users.
Knowing a range of lookup functions lets you work more efficiently and build spreadsheets that are less prone to errors. You'll see each technique explained with numbered steps and then shown in Excel.
It suits CPAs and accountants, CFOs, controllers, bankers, financial planners, consultants, business analysts, bookkeepers and other Excel users.
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.
Human Factors Usability Studies Following ISO 62366 and FDA…
Construction Lending And Real Credit Administration: Evalua…
Validation Statistics for Non-Statisticians
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Batch Record Review and Product Release
Discover how Emotional Intelligence turns AI from a technic…
Female to Female Hostility @Workplace: All you Need to Know
Handbook Overhaul 2026: Compliance, OBBB Act & Beyond
Copilot and HR: An Introduction for HR Professionals
ChatGPT for HR - Build HR Policy Framework and Strategy
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
Fostering a Culture of Respect: Eliminating Gossip, Rumour…
The Perfect Storm Coming to Healthcare: Value Based Care Me…
Major cGMP Issues: FDA Concerns in 2026
Language is Code - Intro to AI - Generative AI - ChatGPT an…
Managing Difficult Employee Conversations
Excel + AI: The Smart User's Guide to Faster, Easier Work w…
The Importance of the first 5 seconds when presenting
Tattoos, hijabs, piercings, and pink hair: The challenges …
2026 Nacha Rules Changes (Part 1): Fraud Monitoring & Ops B…
ChatGPT and Project Management: Leveraging AI for Project M…
I-9 Audits: Strengthening Your Immigration Compliance Strat…
Pivot tables beginner to advanced + 20 advanced Pivot table…
Emotional Intelligence: Mastering the Emotions of Great Lea…
Accounting For Non Accountants : Debit, Credits And Financi…
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Human Error Reduction Techniques for Floor Supervisors