Live Educational Webinar
Excel Efficiency: XLOOKUP
Price: FREE
Nov. 19, 2019 Tuesday
11:00 AM - 12:00 PM (Pacific)
1 Hour
Registration for this event is currently closed
shutterstock_699113008.jpg

Free Live Webinar

  • Free CPE
  • Non-sponsored Events mean you never listen to a 3rd party sales pitch – it’s all just great education
  • Expert-instructor-led learning with live Q&A
  • Based on a great course on Illumeo
David Ringstrom President and CPA, Accounting Advisors Inc
Microsoft announced the new XLOOKUP function for Office 365 in August 2019. As is typical for Office 365 features, this function will be pushed out to users in waves. In this presentation you’ll get an overview of the new XLOOKUP function and see how it compares to both VLOOKUP, HLOOKUP and INDEX/MATCH, as well as the similarities that XLOOKUP has with the obsolete LOOKUP function in Excel.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Learning Objectives

After attending this event you will be able to:
Identify the purpose of Excel’s XLOOKUP function.
State the purpose of the column_index_num argument within VLOOKUP.
Identify the number of criteria pairs that you can specify in the MAXIFS function.
State what the MATCH function returns when the lookup_value is found.

Speakers

David RingstromPresident and CPA, Accounting Advisors Inc
David Ringstrom
President and CPA, Accounting Advisors Inc
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by Jennifer RobbinsIllumeo Webinar Manager
Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 300 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.