Final Project: Your Quarterly Business Review Pack
Lessons in this course
- 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