Transcend VLOOKUP in Microsoft Excel
Duration: 60 Minutes
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.
- 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
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.
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
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.
Upcoming Webinars
By Lesley Crook
Date: June 23, 2026
By Diane L. Dee
Date: June 23, 2026
By David Nettleton
Date: June 24, 2026
By Marcia Zidle
Date: June 24, 2026
By Kathryn E. Strachan
Date: June 25, 2026
By Marcia Zidle
Date: June 25, 2026
By William Mack Copeland
Date: June 26, 2026
By Audrey Halpern
Date: June 29, 2026
By Margie Faulk
Date: July 1, 2026
By Carolyn Troiano
Validation of FDA-Regulated Medical Device and SaMD Products Using AI, ML, and LLMs, such as ChatGPT
Date: July 3, 2026
By Edwin Waldbusser
Date: July 3, 2026
By Steven G. Meilleur
Date: July 7, 2026
By Paul J. Cline
Date: July 7, 2026
By Margie Faulk
DOL Reverses Course on Independent Contractor Rule for 2026! How Will Employers Adapt to the Change?
Date: July 8, 2026
By Beverly Beuermann-King
Date: July 8, 2026
By Deb Schaffer
Date: July 9, 2026
By William J. Rothwell
Date: July 9, 2026
By Bruce Lee
Date: July 10, 2026
By Allen Evitts
Date: July 10, 2026
By David Nettleton
Date: July 14, 2026
By William Mack Copeland
Date: July 14, 2026
By Dev Strischek
Date: July 15, 2026
By Karla Brandau
Date: July 15, 2026
By Dr. Susan Strauss
Date: July 15, 2026
By Ronald L. Adler
Date: July 20, 2026
By Marcia Zidle
Date: July 30, 2026
By Bruce Lee
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Carolyn Troiano
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Marcia Zidle
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Mark Gorkin
Recorded Session
By Paul Pelletier
Recorded Session
By Cathy Horwitz
Recorded Session
By Pete Tosh
Recorded Session
By Mark Gorkin
Recorded Session
By Melveen Stevenson
Recorded Session
By Bob Verchota
Recorded Session
By Don Phin
Recorded Session
By Melveen Stevenson
Recorded Session
By Michael Healey
Recorded Session
By Richard E Cascarino
Recorded Session
By Mike Thomas
Recorded Session
By Paul J. Cline
Recorded Session
By Mike Thomas
Recorded Session
By Brian G. Rosenberg
Recorded Session
