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
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard