Easy to use, low cost CRM using Excel
A dashboard has been provided to display information about the health of the pipeline. Key information includes, values for each stage, success rate and level of activity over the next 30 days.
Drill down to the detail
The spreadsheet has a separate tab to give detailed analysis of each stage of the pipeline. In addition, there is a specific tab to report of marketing activity - look forward to forthcoming events or back to past events, all sorted by date.
Easy data entry
The core data such as leads, contacts and marketing activity is entered in to the relevant tabs on the spreadsheet, in the normal way you use Excel. Large lists of contacts etc can be simply copied and pasted straight in.
The spreadsheet contains a simple contact viewer, which can be easliy reviewed for each contact. The spreadsheet automatically includes details for the organisation, as well as the names of any other related contacts.
We have tried to capture some of the key elements of a CRM system in this spreadsheet. We don't have all the functionality of a dedicated piece of software, but we do provide the core parts, for a fraction of the price.
All you need is a knowledge of using spreadsheets to get going. We have protected various cells to make sure the spreadsheets keeps its integrity. Importantly, there are no macros used, to help reduce any concern of poor software.