Excel Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP Made Easy

You will begin by understanding the concept of making references absolute through naming cells, which allows you to create formulas much easier. You’ll explore the VLOOKUP and HLOOKUP functions in detail, breaking down their arguments to ensure you can use them with confidence. The course will also cover the latest enhancement in Excel’s lookup capabilities, XLOOKUP, a more versatile and user-friendly alternative. Learn what makes XLOOKUP different, including its ability to search in any direction and handle errors more effectively. Gain hands-on experience with practical examples to apply these skills in real-world situations.

• What are Lookup Functions?
• Making References Absolute by Naming Cells
• Defining VLOOKUP and HLOOKUP
• Breaking Down the Arguments
• What Makes XLOOKUP Different?
• Using XLOOKUP

Attending this session will equip you with the skills to work more effectively in Excel when managing large datasets. Lookup functions like VLOOKUP, HLOOKUP, and the newer XLOOKUP are indispensable tools for quickly finding and cross-referencing information. Whether you're an analyst, manager, or anyone who works with data, mastering these functions will save you time and eliminate errors in your spreadsheets. By the end of the course, you'll be proficient in using lookup functions and creating efficient, dynamic Excel models.

This class is ideal for anyone looking to take their Excel skills to the next level and streamline their workflow. Whether you're an analyst, manager, or anyone who works with large datasets, mastering these functions will save you time, reduce errors, and help you extract meaningful insights quickly.

• Financial Analysts
• Accountants 
• Data Analysts
• Project Managers 
• Operations Managers
• Marketing Analysts 
• Sales Managers 
• Supply Chain Managers 
• HR Professionals  
• Researchers 

Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.

Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.

Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.

When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing mid-century furniture.