This webinar effectively teaches lookup techniques and demonstrates practical examples, providing the perspective you need to understand the depth and scope of these functions.
Course Objectives:
To gain a practical “hands-on” understanding of how to manage and effectively use lookup functions, formula auditing and named ranges with confidence, knowledge and consistency.
When it comes to dynamically looking up 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 clear understanding, good habits, and application of correct structure and syntax.
Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.
Understand the power of Excel and get the most out of your software investment.
Course Outline
• Creating named ranges
• Understanding VLOOKUP
• Examples of using VLOOKUP
• Create a VLOOKUP table
• Understand absolute references in VLOOKUP functions
• VLOOKUP to find approximate match
• VLOOKUP to find exact match
• Link VLOOKUP to external data
• Cleansing data for common VLOOKUP issues
• Performing calculations with VLOOKUP
• Use the Insert Function technique to create lookup functions
• Using HLOOKUP
• Formula Auditing with lookup functions
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
• Accountants
• CPAs
• CFOs
• Financial Consultants
• Controllers
• Banking
• Finance
• Insurance
• Education
• Telecom
• IT
• Marketing
• Sales
• Investments
• Pharmaceutical
• Medical Devices
• FDA
• Aviation
• Energy
• Retail
• Human Resource
• Logistics & Supply Chain
• Accounts
• Audit
You don't have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.
3-Hour Boot Camp on Mastering Excel Formulas and Functions
LIVE : Scheduled on
25-November-2026 :01:00 PM EST 180 Minutes View Program |
Advanced Excel Functions: Lookups, Logic, and More
Get Instant Access 90 Minutes View Program |
INTERMEDIATE FUNCTIONS, LOOKUPS & LINKING IN MS EXCEL
Get Instant Access 90 Minutes View Program |
Microsoft Excel®: Lookup Functions and 3-D Excel file
Get Instant Access 90 Minutes View Program |
KEY ESSENTIALS OF FORMULAS FUNCTIONS & AUTOMATIC CALCULATION IN MS EXCEL
Get Instant Access 90 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry