Excel Lookup Essentials Setup Data Cleanse And Formula Auditing
-
Speaker : RAY EVANS
-
When : Monday, November 03, 2025
-
Time : 01 : 00 PM EST
-
Add To Calendar
Refer a Friend
Ray’s professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 30,000 students, business owners and executives since 1990 and authored a wide range of training and procedural documentation, complex reports and engaging internet content, Ray has demonstrated strong ability in key communication styles and knowledge transfer.
To provide the best learning and knowledge retention experience for attendees, Ray’s webinars replicate the in-person classroom experience and include:
- A comprehensive step-by-step Learning Guide
- Demonstrations and practical exercises
- Exercise files; and
- Productivity techniques
In this “easy-learn” webinar, Ray Evans clearly demonstrates the essentials of VLOOKUP and HLOOKUP setup, structure, and options, and how this knowledge can significantly save time, preserve accuracy, highlight errors, and boost productivity.
Lookup functions can match, retrieve, and merge data between tables with exact and range matches using absolutes and named ranges.
VLOOKUP is an Excel function that looks up and retrieves data in a vertical table, where data is organized in rows.
HLOOKUP is an Excel function that looks up and retrieves data in a horizontal table with data in columns.
When it comes to dynamically matching and retrieving information from small or huge tables of data, Lookup functions can elevate you to a new world of accuracy, productivity, and time savings in Excel.
To work efficiently with lookup functions, you must start with a clear understanding, good habits, and application of correct table and function structure and syntax.
Mastering lookup functions and techniques is a valuable skill set in Excel and is vital in a wide range of professions and fields, including public service, banking, accounting, financial analysis, and business administration.
Areas Covered
- Understanding VLOOKUP syntax
- Examples of using VLOOKUP
- True and False - The 4th Parameter Demystified
- Table setup essentials for lookup functions
- VLOOKUP Range Lookup using absolute references
- VLOOKUP Exact match using absolute references
- HLOOKUP Range Lookup using absolute references
- HLOOKUP Exact match using absolute references
- Cleansing data for VLOOKUP accuracy
- Formula Auditing to trace, edit, and correct formulas and functions
- Keyboard shortcuts – Excel, general, and web browser
Who Should Attend
- All Excel Users
- Account Executives
- Accountants
- Auditors
- Bookkeepers
- Business Owners
- Chief Executives
- Controllers
- CPA's
- Cybersecurity staff
- Database Administrators (DBA)
- Educators
- Trainers
- Engineers
- Financial Analysts
- Human Resource Personnel
- IT Professionals
- Managers
- Marketers
- New Recruits
- Project Managers
- Social Media Specialists
- Staff at all levels
- Supervisors
-
$160.00
-
