VLOOKUP Courses and Certifications

ExcelIsFun

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

Learn to create reusable Excel invoices using advanced functions like VLOOKUP, IF, and data validation. Master invoice formatting, calculations, and automated invoice numbering for efficient business operations.

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

ExcelIsFun

Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework

Master VLOOKUP for incentive pay calculations, including piecework and commissions. Learn to create lookup tables and apply VLOOKUP for various business scenarios with 15 practical examples.

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

ExcelIsFun

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

Learn to leverage Excel's Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more. Master efficient data management and analysis techniques for improved productivity.

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

ExcelIsFun

Excel Basics - Excel VLOOKUP Function Made Easy

Master Excel's VLOOKUP function with 9 practical examples, from exact matches for product pricing to approximate matches for commission calculations, enhancing your data analysis skills.

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

ExcelIsFun

IF or VLOOKUP Function for Assigning Categories with Excel Formula - 8 Examples

Learn advanced Excel techniques for assigning categories using IF and VLOOKUP functions. Master data organization, formula creation, and efficient lookup methods for various scenarios.

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

ExcelIsFun

Mysteries of VLOOKUP Function Revealed - Amazing Examples

Comprehensive tutorial on VLOOKUP function in Excel, covering 15 examples from basic to advanced usage, including exact and approximate matches, dynamic tables, and error handling.

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

Simon Sez IT

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

Master essential Excel lookup functions: VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP. Learn exact and approximate matches, expanding data, and combining functions for efficient data retrieval and analysis.

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

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

Credential

Excel for Data Analytics

130 ratings at Noble Desktop

Master essential Excel functions, formulas, and advanced techniques like Pivot Tables and VLOOKUP to enhance your data analysis capabilities and streamline your analytical workflow.

• Noble Desktop
• 18 hours
• Self-Paced
• $595.00

Data Analysis in Excel

93 ratings at DataCamp

Build real-world Excel skills in just 4 hours. This course will show you time-saving shortcuts and essential functions.

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

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

Fundamentals of Data Analysis in Excel – Case Study

33 ratings at Corporate Finance Institute

Put your data analysis skills to the test by taking on seven challenges across a wide range of areas in Excel

• Corporate Finance Institute
• 1 hour 5 minutes
• Self-Paced
• Paid Course

Data Analysis in Google Sheets

15 ratings at DataCamp

Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.

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

Excel Fundamentals

Gain the essential skills you need to use Excel, from preparing data to writing formulas and creating visualizations. No prior experience is required.

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

Google Sheets Fundamentals

Become a Google Sheets master. Learn the core skills you need to analyze data using Google Sheets.

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