Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#VLOOKUP Function

Showing: 8 courses
ExcelIsFun

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

1 rewiews
Comprehensive payroll solution using advanced Excel functions like SUMIFS, MROUND, MOD, and VLOOKUP. Learn to calculate hours, deductions, and taxes efficiently.
Add to list
18 Lesons
29 minutes
On-Demand
Free-Video
ExcelIsFun

Mysteries of VLOOKUP Function Revealed - Amazing Examples

0 rewiews
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.
Add to list
18 Lesons
1 hour 9 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
Learn advanced Excel techniques for assigning categories using IF and VLOOKUP functions. Master data organization, formula creation, and efficient lookup methods for various scenarios.
Add to list
9 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
10 Lesons
37 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
Learn to calculate federal income tax withholdings using VLOOKUP and MAX functions in Excel, with practical examples for different marital statuses and pay periods.
Add to list
10 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

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

0 rewiews
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.
Add to list
17 Lesons
1 hour 21 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - Excel VLOOKUP Function Made Easy

0 rewiews
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.
Add to list
18 Lesons
40 minutes
On-Demand
Free-Video
Learnit Training

Microsoft Excel 2016 - Beginners Tutorial Video

0 rewiews
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.
Add to list
15 Lesons
2 hours 9 minutes
On-Demand
Free-Video