Completed
) Why Excel is so Helpful AND why we must be REALLY Knowledgeable with Excel.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Incentive Pay such as: Straight Piecework, Variable Piecework, Straight Commission, Variable Commission Rates, Commission Rate Based on Amount of Sales
- 3 ) Straight Piecework Example
- 4 ) Variable Piecework Example Making the Calculations Long-Hand
- 5 ) Why Excel is so Helpful AND why we must be REALLY Knowledgeable with Excel.
- 6 ) Variable Piecework Example Making the Calculations with the “Lookup Table Method”
- 7 ) Creating the Lookup Table from Scratch
- 8 ) Variable Piecework Example Making the Calculations with the “Lookup Table Method & VLOOKUP Function using Approximate Match”
- 9 ) Variable Piecework & VLOOKUP & Approximate Match Lookup for Entire Payroll Table:
- 10 ) What is VLOOKUP Function?
- 11 ) “Mash” all 3 VLOOKUP Functions into Single Formula using Clipboard:
- 12 ) Lookup Tables are Everywhere
- 13 ) Straight Commission Rates
- 14 ) VLOOKUP & Exact Match Lookup for Straight Commission Rates When each Employee has Different Rate
- 15 ) VLOOKUP & Approximate Match Lookup for Variable Commission Rates; Make Lookup Table and use VLOOKUP
- 16 ) VLOOKUP & Approximate Match Lookup for Commission Rate Based on Amount of Sales Made by the Employee
- 17 ) Summary
