VLOOKUP Function Courses and Certifications

Excel Conditional Formatting from Basics to Formulas- SMASH!

128 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

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

57 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

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

ExcelIsFun

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

1 review

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

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

Microsoft Excel Formulas You Need to Know in 30 Minutes!

Master essential Excel formulas and functions in 30 minutes. Perfect for beginners, this class covers arithmetic, cell referencing, SUM, COUNT, VLOOKUP, and more, with downloadable practice files.

• Skillshare
• 34 minutes
• On-Demand
• Free Trial Available

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 - 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

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

Learnit Training

Microsoft Excel 2016 - Beginners Tutorial Video

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

Introduction to Data Analysis using Microsoft Excel

3534 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

Poznaj Excela w jedną godzinę!

578 ratings at Udemy

Intensywne wprowadzenie do Excela: od podstaw obsługi arkusza po zaawansowane funkcje. Praktyczne ćwiczenia dla zwiększenia efektywności pracy i rozwoju kariery.

• Udemy
• 1 hour
• On-Demand
• Free Online Course