Deal Desk Dashboard: KPIs and Conditional Formatting
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- From List Price to Pocket Price: the Deal Price Waterfall (Chart)Free
- Headline vs Effective Discount and Price per Seat Pro
- Margin Floor Check per Deal Pro
- Approval Routing Matrix: Discount Band × Deal Size (INDEX/MATCH, IFS) Pro
- Multi-Year Deals: Ramped Pricing, TCV and ACV Pro
- The Cost of Non-Standard Terms: Payment Timing (NPV) and Free Months Pro
- Discount Leakage by Rep and Region (SUMIFS, Outliers) Pro
- Deal Desk Dashboard: KPIs and Conditional Formatting Pro