This class focuses on the new XLOOKUP function which was added to Excel 365 in 2019. We will learn all of the ways to use XLOOKUP in addition to double-lookups (two-way lookups). We will also take some time to go over some string manipulation functions, turn on the Developer toolbar, and learn how to create Combo Boxes. Click here for the Full Outline.

Lessons

• 00. Introduction (4:38)
• Lesson 01. Video Time Conversion (27:37)
• Lesson 02. XLOOKUP Part 1 (13:28)
• Lesson 03. XLOOKUP Part 2 (11:13)
• Lesson 04: XLOOKUP Part 3 (16:48)
• Lesson 05: Review (2:49)

Resources

• Full Course Outline
• Handbook PDF - Coming Soon
• Skills Test Quiz - Coming Soon
• Certificate of Completion
• Post-Class Survey

Questions

Post your questions or comments below