Commission tracking, pipeline reporting, and territory analysis — the formulas sales teams use every day.
=sales_amount * commission_rate
=B2 * 0.08 (8% commission on the sale in B2)=IF(B2>=100000, B2*0.12, IF(B2>=50000, B2*0.10, B2*0.08))
-- 12% on deals over 100k, 10% on 50k-100k, 8% below=SUMIF(stage_column, "Proposal", value_column)
-- Total value of all deals in the Proposal stage=COUNTIFS(rep_column, "Sarah", outcome_column, "Won") /
COUNTIFS(rep_column, "Sarah", outcome_column, "<>Open")
-- Won deals divided by closed deals (won + lost)=(actual - target) / target * 100
-- Percentage above or below target=RANK(B2, $B$2:$B$20, 0)
-- Rank of this rep's sales among all reps (0 = largest first)Convert your CRM export to an Excel Table, then build a pivot table with Rep in Rows, Stage in Columns, and Sum of Value as the value. Add a slicer for Month and you have a live pipeline dashboard that updates in seconds.
ExcelPro has 880+ hands-on exercises across 9 tracks — type real formulas, get instant feedback.
Start practising free →