Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework
Offered By: ExcelIsFun via YouTube
Course Description
Overview
Syllabus
) Introduction.
) Incentive Pay such as: Straight Piecework, Variable Piecework, Straight Commission, Variable Commission Rates, Commission Rate Based on Amount of Sales.
) Straight Piecework Example.
) Variable Piecework Example Making the Calculations Long-Hand.
) Why Excel is so Helpful AND why we must be REALLY Knowledgeable with Excel..
) Variable Piecework Example Making the Calculations with the “Lookup Table Method”.
) Creating the Lookup Table from Scratch.
) Variable Piecework Example Making the Calculations with the “Lookup Table Method & VLOOKUP Function using Approximate Match”.
) Variable Piecework & VLOOKUP & Approximate Match Lookup for Entire Payroll Table:.
) What is VLOOKUP Function?.
) “Mash” all 3 VLOOKUP Functions into Single Formula using Clipboard:.
) Lookup Tables are Everywhere.
) Straight Commission Rates.
) VLOOKUP & Exact Match Lookup for Straight Commission Rates When each Employee has Different Rate.
) VLOOKUP & Approximate Match Lookup for Variable Commission Rates; Make Lookup Table and use VLOOKUP.
) VLOOKUP & Approximate Match Lookup for Commission Rate Based on Amount of Sales Made by the Employee.
) Summary.
Taught by
ExcelIsFun
Related Courses
Become an Accounts Payable OfficerLinkedIn Learning Become an Accounts Payable Officer
LinkedIn Learning Excel & Business Math - Simple Interest Calculations & Short Term Loans
ExcelIsFun via YouTube Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
ExcelIsFun via YouTube Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More
ExcelIsFun via YouTube