First steps with VLOOKUP and XLOOKUP in Excel

Join me for a hands-on walkthrough of your first steps with VLOOKUP and XLOOKUP in Excel. This session introduces these essential functions, focusing on how Excel users can quickly search data, connect tables, and streamline workflows with practical, time-saving techniques.

Recording & downloads

• A link to the recording will be emailed to everyone who registered after the event.
• All downloads used during the event will be shared with attendees.

By the end of this free online training, you’ll understand:

• How VLOOKUP retrieves data from large tables to simplify lookups and reporting.
• The basics of setting up XLOOKUP for flexible, error-proof data searches.
• The fundamentals of automating tasks and creating dynamic, accurate spreadsheets.

Who this is for

Typical job titles might include:

• Data analysts
• Financial analysts
• Marketing coordinators
• Accountants
• Controllers
• Operations analysts

Prerequisites

• To make the most of the workshop, you should have some experience with Excel, such as working with relative and absolute references, conditional statements and basic charts.
• Please confirm you have a version of Excel with both the VLOOKUP and XLOOKUP functions available.
• No other preparation is needed.

About your instructor

George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics (O'Reilly, 2024). He is a recipient of the Most Valuable Professional (MVP) award from Microsoft for technical excellence & community advocacy.

I look forward to seeing you at the event!

If your team is looking for custom data analytics training, check out my corporate workshops.