Transcend VLOOKUP in Microsoft Excel
Go beyond Excel's Vlookup function to overcome its limitations.
Speaker
Craig Brody
Software trainer and consultant · Craig Brody, LLC · Trainer for Wharton and Penn Carey Law
Overview
Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.
Why attend: Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.
What’s covered
- Review of Vlookup
- See how the XLOOKUP function overcomes Vlookup's limitations in a side by side comparision
- See how XLOOKUp can lookup data in any direction
- Use XLOOKUP for 2 way lookups and built-in error messaging
- Apply XLOOKUP in exact and approximate match examples
- Index and Match functions
- Defined Names command
Who should attend
What you get
About the speaker
Craig Brody operates Craig Brody, LLC, a business that provides software training and consulting services. Craig has trained numerous employees, managers, executives, and students in various application software, including Microsoft 365 Copilot and Adobe Acrobat Pro. He conducts and facilitates in-person, online, and recorded training workshops for professionals in accounting, business, management, and law. Craig also conducts workshops, classes, and consulting services for the University of Pennsylvania's Wharton Business School, Penn Carey Law School, law firms, accounting associations, and accreditation providers. His services include spreadsheet analysis, design and troubleshooting, software programming, consulting, published course guides, recorded courseware videos, and other reference materials.
Staci Warne · 60 min
Cathy Horwitz · 180 min
Ritu Arora · 60 min