Overview:

Join Simon Pound, QA's Senior Technical Learning Specialist for Digital Productivity and Office Applications for this fantastic free session where he will show you how to become proficient with the critical VLOOKUP function and explore the newer XLOOKUP function. 

This webinar will take you through the fundamentals of mastering these important functions, explore best practices and includes hints and tips which should improve the efficiency with which you work with not only LOOKUPS but also with concepts which may be applied to any Excel function:

• Preparation - Useful hotkeys to increase the efficiency with which we can create our LOOKUPs
• VLOOKUPs - Approximate and exact matches with error trapping
• Using named ranges to simplify LOOKUPs
• Introducing the new XLOOKUP function
• Exploring the pros and cons of VLOOKUP v XLOOKUP

Target audience:

This webinar is aimed at people who want to improve their efficiency with Excel through beginning to master LOOKUP functions, specifically the popular VLOOKUP and introducing the newer XLOOKUP.

About the speaker:

Simon Pound, QA's Senior Technical Learning Specialist for Digital Productivity and Office Applications.