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

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