Sales pipeline (CRM)

A simple CRM like the ones companies use: each deal at a pipeline stage, chance of closing with VLOOKUP, weighted value, a summary by stage and a funnel chart.

Area: Sales. Level: Intermediate.

Functions used: VLOOKUP, SUM, SUMIF, COUNTIF, COUNTA.

• Next project: Time tracking by project
• All projects
• Lessons