VLOOKUP Function Courses and Certifications

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Trial Available

Coursera

Introduction to Data Analysis using Microsoft Excel

4669 ratings at Coursera

Learn essential Excel data analysis skills: sorting, filtering, IF and VLOOKUP functions, and PivotTables. Gain practical experience using sample sales data to efficiently analyze and summarize information.

• Coursera
• 1 hour 37 minutes
• On-Demand
• Paid Course

ExcelIsFun

Excel VLOOKUP Function - All You Need to Know

Comprehensive guide to mastering VLOOKUP function in Excel, covering basic to advanced techniques for efficient data lookup and manipulation.

• YouTube
• 1 hour 8 minutes
• On-Demand
• Free Video

Excel Conditional Formatting from Basics to Formulas- SMASH!

134 ratings at Udemy

Learn all about Conditional Formatting. From Beginner Level to Formula/Function Based Advanced Exercises

• Udemy
• 1 hour 46 minutes
• On-Demand
• Paid Course

Learnit Training

Microsoft Excel 2016 - Beginners Tutorial Video

1 review

Comprehensive Excel 2016 tutorial covering basics to advanced features. Learn data entry, formulas, functions, pivot tables, charts, and macros. Ideal for beginners seeking to master Excel essentials and beyond.

• YouTube
• 2 hours 9 minutes
• On-Demand
• Free Video

Excellence in Excel! Create a Stock Control tool in Excel!

58 ratings at Udemy

Learn how to use Excel by creating a valuable stock control tool in Excel.

• Udemy
• 1 hour 33 minutes
• On-Demand
• Paid Course

ExcelIsFun

LOOKUP Function Beginner to Advanced 23 Examples - Excel VLOOKUP WEEK Video

Master Excel's LOOKUP function with 23 practical examples, from basic to advanced applications. Enhance your data analysis skills and streamline your spreadsheet workflows.

• YouTube
• 46 minutes
• On-Demand
• Free Video

Working with Real-Time Data in Excel

57 ratings at LinkedIn Learning

Learn how to quickly feed real-time data from an API directly into Excel using WEBSERVICE and FILTERXML functions, enabling powerful insights and real-time analytics.

• LinkedIn Learning
• 1-2 hours
• On-Demand
• Free Trial Available

ExcelIsFun

Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More

3 reviews

Comprehensive payroll solution using advanced Excel functions like SUMIFS, MROUND, MOD, and VLOOKUP. Learn to calculate hours, deductions, and taxes efficiently.

• YouTube
• 29 minutes
• On-Demand
• Free Video

ExcelIsFun

Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost

Learn to calculate trade discounts and wholesale costs using Excel functions like VLOOKUP and IF. Master business terms and automate calculations for single and series discounts in retail and wholesale scenarios.

• YouTube
• 37 minutes
• On-Demand
• Free Video

ExcelIsFun

Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

Learn to calculate federal income tax withholdings using VLOOKUP and MAX functions in Excel, with practical examples for different marital statuses and pay periods.

• YouTube
• 30 minutes
• On-Demand
• Free Video