Ravi Sir's Cards › Excel
Sales CRM System in Excel (card 1 of 2)
Revision card 1 for Sales CRM System in Excel: Weighted value: =F5*H5 gives ₹4,80,000; Lead ID: ="LD-"&TEXT(ROW()-4,"000") gives LD-001; Days open: =IF(K5="",Setup!$B$3,K5)-B5 gives 23. Includes an example data table.
Read card text
What this card says
1 for Sales CRM System in Excel: Weighted value: =F5*H5 gives ₹4,80,000
Lead ID: ="LD-"&TEXT(ROW()-4,"000") gives LD-001
Days open: =IF(K5="",Setup!$B$3,K5)-B5 gives 23. Includes an
Example
data table
Learn this in the lesson: Sales CRM System in Excel: Leads, Stages, Weighted Pipeline, Follow-up Reminders, Win Rate by Source and Dashboard