The Sales Pipeline Dashboard follows each deal from first lead through qualification, proposal and negotiation to won or lost. The Deals tab records the company, owner, stage, deal value, your probability for the deal and the expected close date. Weighted value is worked out from value and probability. The Dashboard shows the weighted open pipeline, won value, win rate and charts by stage and by owner.

The file comes with sample data for twelve deals, so you can see how it works. Make a copy, replace the sample rows with your own deals, and the totals, win rate and charts update on their own.