Uploaded June 2026 | Updated September 2026, 2 weeks ago

---

🔥Join 6,000+ Busy professionals learning Microsoft Copilot➡️learncopilot.ai/masterclass

Calculating sales commissions by hand in Excel is exactly how errors sneak in — one salesperson lands in the wrong tier and the whole sheet is off. In this Short I show you how to use Copilot in Excel to calculate tiered commissions automatically. With one table of salespeople and one commission-rate table, Copilot adds two columns — the commission rate and the commission owed — using an approximate-match lookup to put every person in the right tier. No more guessing, no more 0% when it should be 3%.