Add a dynamic variable commission calculation to your sales run sheets to show your reps what they earn on each order with VLOOKUP.
- So we've showed you how dynamic tables can be…in terms of adding columns and rows automatically.…And automatically calculating formulas.…In one case we used a simple commission formula,…the 15% applied to sales.…Unfortunately that's not always true.…Not all our sales reps have the same commission rate.…Some may have a fully earned commission rate.…Some may be on a probationary rate.…Here we're going to break a little bit of convention…and do two formulas.…So for this course we'll be at three formulas total.…Not scary formulas.…In fact the reason we're doing it,…is the formula we're going to go over…is one of the most used formulas in all of Excel.…
In any business discipline,…whether it's sales, finance, marketing.…It's called VLOOKUP.…And it allows you to look up an object or an item.…Let's say in this case we're going to look up…sales rep name.…And we're going to compare that against a commission table.…And return the specific commission for that sales rep…and be able to calculate total commission…for that sales rep.…
- Using, modifying, and sharing templates
- Importing data from a database
- Cleaning up data
- Refreshing queries
- Pasting data
- Sorting and filtering tables
- Using slicers
- Adding a dynamic commission calculation
- Using conditional formatting
- Working with PivotTables and PivotCharts
- Creating a leaderboard
- Create period, monthly, and yearly summaries
- Creating dashboards
Skill Level Intermediate
1. Getting Started with Templates
2. Importing Sales Data
3. Working with Tables
4. Analyzing Sales Data
5. Build Awesome Sales Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.