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.
Areas Covered in the Session
- 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 Will Benefit
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
Speaker Profile
Craig Brody runs Craig Brody, LLC, a software training and consulting business. Craig has trained thousands of employees, managers, executives and students in application software including Microsoft 365 and Adobe Acrobat Pro. Conducts and facilitates in person and online training workshops for professionals in the fields of Accounting, Business, and Law. Conducts workshops, classes and consulting services for the University of Pennsylvania’s Wharton Business School and Penn Carey Law School. Provides clients with spreadsheet analysis and design, software programming, consulting services and course curriculum including videos, reference guides and related materials
Instructor
Craig Brody