+1-800-385-1627
support@webinarpanel.com
Transcend VLOOKUP in Microsoft Excel
Craig Brody
Access Recorded Version
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Support
Call : +1-800-385-1627
Mailto : support@recordedwebinars.com
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