Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Weekly Activity Log: Counting Calls and Meetings with COUNTIFSLabFree
  2. Pipeline by Stage and the Weighted Forecast (SUMPRODUCT)Lab Locked
  3. Win Rate and Average Deal SizeLab Locked
  4. Sales Cycle Length: Days from Created to ClosedLab Locked
  5. Quota Attainment and the Gap to QuotaLab Locked
  6. Tiered Commission: Rates per Tier with MIN and MAXLab Locked
  7. Discounts: What They Cost in Margin and in CommissionLab Locked
  8. Ranking Your Accounts: RANK, LARGE and the Top 3Lab Locked
  9. Price Quote Builder: Volume Discounts with XLOOKUPLab Locked
  10. Monthly Sales Report: Year-on-Year Growth and a Trend ChartLab Locked
  11. Your Sales Dashboard: Attainment by Product, Chart and ColoursLab Locked
  12. Pipeline Hygiene: Past-Due Close Dates, Stale Deals and a Clean ForecastLab Locked
  13. Stage Conversion Rates: Win Probabilities from Your Own HistoryLab Locked
  14. Working Backwards: Pipeline, Meetings and Calls Needed for the Quota GapLab Locked
  15. Forecast Categories: Commit, Best Case and the Number You CallLab Locked
  16. Territory Planning: Wallet Share, Whitespace and Where to Spend Your VisitsLab Locked
  17. Multi-Year Deals: TCV, ACV, Ramped Pricing and a Capped KickerLab Locked
  18. Commission What-If: Sign the Deal This Quarter or Next?Lab Locked
  19. Bookings Bridge: Volume and Price Effects vs Last YearLab Locked
  20. Final Project: Your Quarterly Business Review PackLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy