Excel for Sales Reps: Pipeline, Forecast, Quota & Commission
20 hands-on labs for B2B account executives: activity log, weighted pipeline forecast, win rate, sales cycle, quota attainment, tiered commission, discount impact, account ranking, a volume-discount quote, a monthly sales report and a sales dashboard, then pipeline hygiene, stage conversion from your own history, an activity plan worked back from the quota gap, forecast categories, territory whitespace, multi-year deals, a commission what-if, a volume and price bridge and your quarterly business review.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course follows Maya, an account executive selling label systems, through a sales year. In 20 hands-on labs you count activities with COUNTIFS, weight the pipeline with SUMPRODUCT, measure win rate, deal size and sales cycle, track quota attainment, check a tiered commission statement, price discounts and volume quotes, rank accounts and build a monthly report and a dashboard. The second half goes deeper: you clean the pipeline of past-due and stale deals, derive stage probabilities from your own history, work back from the quota gap to calls per week, build a forecast range from commit and best-case categories, plan a territory by wallet share and whitespace, value multi-year deals by TCV and ACV, test the commission effect of deal timing, split growth into volume and price with a waterfall bridge and finish with a quarterly business review.
Lessons
- Weekly Activity Log: Counting Calls and Meetings with COUNTIFSFree
- Pipeline by Stage and the Weighted Forecast (SUMPRODUCT) Locked
- Win Rate and Average Deal Size Locked
- Sales Cycle Length: Days from Created to Closed Locked
- Quota Attainment and the Gap to Quota Locked
- Tiered Commission: Rates per Tier with MIN and MAX Locked
- Discounts: What They Cost in Margin and in Commission Locked
- Ranking Your Accounts: RANK, LARGE and the Top 3 Locked
- Price Quote Builder: Volume Discounts with XLOOKUP Locked
- Monthly Sales Report: Year-on-Year Growth and a Trend Chart Locked
- Your Sales Dashboard: Attainment by Product, Chart and Colours Locked
- Pipeline Hygiene: Past-Due Close Dates, Stale Deals and a Clean Forecast Locked
- Stage Conversion Rates: Win Probabilities from Your Own History Locked
- Working Backwards: Pipeline, Meetings and Calls Needed for the Quota Gap Locked
- Forecast Categories: Commit, Best Case and the Number You Call Locked
- Territory Planning: Wallet Share, Whitespace and Where to Spend Your Visits Locked
- Multi-Year Deals: TCV, ACV, Ramped Pricing and a Capped Kicker Locked
- Commission What-If: Sign the Deal This Quarter or Next? Locked
- Bookings Bridge: Volume and Price Effects vs Last Year Locked
- Final Project: Your Quarterly Business Review Pack Locked
Learner reviews
Be the first to review this course.