VLOOKUP Courses and Certifications

ExcelIsFun

Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar

Learn Excel for accounting workflows through formulas, payroll reports, PivotTables, charts, Power Query, and data-model reporting.

• YouTube
• 2 hours 22 minutes
• Self-Paced
• Free Video

Intermediate Excel

3576 ratings at CreativeLive

Build intermediate Excel skills with lookup and conditional functions, PivotTables, database filtering, text manipulation, and combo charts.

• CreativeLive
• Self-Paced
• Paid Course

Kevin Stratvert

Stop Using VLOOKUP for Reports - This Excel Workflow Is Better

Master Excel reporting with data models and pivot tables instead of VLOOKUP to create dynamic, maintainable reports that update with a single refresh.

• YouTube
• 12 minutes
• Self-Paced
• Free Video

ExcelIsFun

Data Modeling - VLOOKUP, Power Query or Power Pivot?

Compare VLOOKUP, Power Query, and Power Pivot for modeling multiple tables and building PivotTable reports.

• YouTube
• 45 minutes
• Self-Paced
• Free Video

ExcelIsFun

Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

Create reusable Excel invoices with product drop-downs, VLOOKUP price retrieval, conditional formulas, totals, and automatically incrementing invoice numbers.

• YouTube
• 31 minutes
• Self-Paced
• Free Video

ExcelIsFun

Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More

Learn how Excel Tables create dynamic ranges that automatically update VLOOKUPs, data-validation lists, charts, PivotTables, and formulas as records change.

• YouTube
• 37 minutes
• Self-Paced
• Free Video

Simon Sez IT

Lookup Functions in Excel - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

Learn to use Excel lookup functions—including VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP—to retrieve data between tables.

• YouTube
• 1 hour 10 minutes
• Self-Paced
• Free Video

Simon Sez IT

Top Ten Excel Formulas and Functions - IF, VLOOKUP, PMT, INDEX MATCH - Excel Tutorial

Learn Excel’s core formulas and functions, from SUM and IF statements to PMT, VLOOKUP, HLOOKUP, and INDEX MATCH.

• YouTube
• 52 minutes
• Self-Paced
• Free Video

Analyzing Data in Spreadsheets

29 ratings at DataCamp

Learn how to analyze data with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().

• DataCamp
• 3 hours
• Self-Paced
• Free Trial Available

Build Your Own InsurTech Pricer

3 ratings at Corporate Finance Institute

Build your own InsurTech pricer to estimate insurance costs based on various inputs

• Corporate Finance Institute
• 17 minutes
• Self-Paced
• Paid Course

Build Your Own Robo-Advisor

3 ratings at Corporate Finance Institute

Build your own robo-advisor model to suggest a wealth management portfolio based on various inputs

• Corporate Finance Institute
• 19 minutes
• Self-Paced
• Paid Course

Career Certificate

Excel Level II: Intermediate Course Online (Self-Paced)

Build intermediate Excel skills for lookup functions, data summaries with Pivot Tables, database organization, data validation, and advanced charts.

• Noble Desktop
• Self-Paced
• $249.00

Simon Sez IT

Excel Data Analysis: VLOOKUP, HLOOKUP, XLOOKUP, and Power Query Functions

1 rating

Master essential Excel lookup functions (VLOOKUP, HLOOKUP, XLOOKUP) and Power Query techniques for efficient data analysis, transformation, and reporting in complex datasets.

• YouTube
• 1 hour 36 minutes
• Self-Paced
• Free Video

Teacher's Tech

How to Use VLOOKUP in Google Sheets - Beginner's Tutorial

Master VLOOKUP in Google Sheets: Find and match data efficiently. Step-by-step examples cover basics to advanced techniques, including multiple criteria and error handling.

• YouTube
• 13 minutes
• Self-Paced
• Free Video

ExcelIsFun

Fixing N/A Errors in XLOOKUP and VLOOKUP - Hidden Characters Problem

Master troubleshooting techniques for #N/A errors in Excel lookups by identifying and fixing hidden characters using functions like CODE, CHAR, REGEXREPLACE, and advanced formulas.

• YouTube
• 17 minutes
• Self-Paced
• Free Video