Secrets of Excel Lookup Functions
April 10, 2024
15 May, 2024 @ 12 PM EDT | 5 PM BST
Webinar
Which side are you on? Are you Team VLOOKUP or Team INDEX/MATCH? There are good reasons for being on either side. But the new XLOOKUP, particularly with the rarely used options, can run circles around VLOOKUP or INDEX/MATCH. Also take a look at the rarely used CHOOSE, SWITCH, IFS, and more. Join Bill Jelen from MrExcel for an hour-long webinar covering lookup functions in Excel.
Key Topics Covered:
- Troubleshooting VLOOKUP
- How INDEX/MATCH is faster for returning 12 months of data
- How XLOOKUP is even faster than INDEX/MATCH
- The specialty lookups like CHOOSE and SWITCH
Join us for an enlightening hour-long webinar where he will reveal secret tips and tricks on Excel lookup functions! Plus, you can earn a CPE credit along the way.
*If you can’t make the live webinar, register anyway and we will send you the webinar recording and related materials shortly after the broadcast.
Secure Your Spot Today!
About the Presenter
Bill Jelen is the host of MrExcel.com and the author of 68 books about Microsoft Excel including: Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
Jelen produced over 2400 episodes of his Excel video podcast entitled “Learn Excel from MrExcel“. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.
Additional Resources
Connect with us on our social networks:
