Excel Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP Made Easy
Aug 20 |
01:00 PM ET / 12:00 PM CT / 11:00 AM MT / 10:00 AM PT | |
| Duration: 60 minutes | Speaker: Cathy Horwitz | |
CREDITS:
Days
Hours
Mins
Secs
PURCHASE OPTIONS
ABOUT THE EVENT
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.
Why Should You Attend
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.
Areas Covered In The Session
- What are Lookup Functions?
- Making References Absolute by Naming Cells
- Defining VLOOKUP and HLOOKUP
- Breaking Down the Arguments
- What Makes XLOOKUP Different?
- Using XLOOKUP
Who Should Attend
This class is ideal for anyone looking to take their Excel skills to the next level and streamline their workflow. Weather your'e an analyst, manager or anyone who works with large datasets, mastering these functions will save your 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
Cathy believes that when you know the capabilities of the software you use, you will demonstrate improved productivity, will be more efficient and will be able to problem solve more easily. Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access and Outlook. Cathy has over 30 years of experience in classroom and virtual training and has been an instructor of Microsoft Office since its inception. Her strengths include customizing classes based on the needs of individual students and providing realistic business examples to compliment training. She is a high energy trainer with a flair for training the adult student. She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches. When not teaching, Cathy enjoys gardening, shopping estate sales and refinishing mid-century furniture.
Compliance Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: https://www.nasbaregistry.org.
Credits: 1.0
Why You Should Subscribe?
Unlimited Live and On-Demand Courses
Watch all live or recorded webinars (up to 120 minutes long). Get instant access to a library of more than 500 high quality courses presented by best-in-class presenters.
CEUs: APA, CPE, SHRM and HRCI Credits
Fulfil your recertification requirements by earning CEUs from APA, CPE, SHRM and HRCI.
Free Access to Course Materials
Each program comes with Additional Course Materials, which you can download and read anytime.
Additional Discounts
Get flat 20% discount on Premium Product Category like, Long Hour Webinars.
Call Now At
888-527-3477
Email Us At
Testimonials
What people are saying about us
Kari Annen
Client
Elga was very engaging to listen and learn from. She gave good examples to follow.
Elizabeth Jeffery
Client
The speaker was extremely knowledgeable. Speaker moved the program forward at a good pace. The time flew by.
Sheri
Client
The presenter is knowledgeable about the topic and makes the webinar interesting
Maria
Client
The instructor was very detailed on the questions to ask, and the difference between what's reasonable and what's not reasonable.
Monica
Client
The knowledge that the presenter shared. Her enthusiasm was awesome!
Bebe
Client
After seeing a few different tutorials on the subject, this is the first one that included real-world "heads up" advice for getting the most out of the pivot table environment. The presenter was Extremely knowledgeable.
Get Unlimited Webinars, Starting $799 only!
- Unlimited Live and On-Demand Webinars (Up to 120 Minutes Long)
- Unlimited Course Materials
- CEUs: APA, CPE, SHRM and HRCI
- 20% Discount on Long Hour Webinars
- Certificate of Participation
Choose Membership
Similar Events
Sep 17th 2025 @ 01:00 PM ET
Payroll Tax for Non-Resident F-1 & J-1 VISA Holders
Sep 10th 2025 @ 01:00 PM ET
Understanding Deductions, Allowances and Hardship Exemptions in HUD Multifamily Properties: Now and After HOTMA
Jul 17th 2025 @ 01:00 PM ET
Ready. Score. Pass. Mastering NSPIRE Before Inspection Day
Jul 08th 2025 @ 01:00 PM ET
Child Support: What Payroll Doesn’t Know Can Hurt You
Event Calendar
Our Accreditation Partner
PAYMENT
100% secure payments. All major credit and debit cards are accepted.
