Excel First

Excel Solutions

Excel CRM Tool for Personal Use

If you’re looking for a Client Relationship Management tool,

you can try the Excel CRM. The lite version has 3 modules active: Contacts, Organizations and Calendar, these are the most popular.

Download Excel CRM: Excel CRM lite.xslm

The full version has a lot more modules, as you will see on the opening page. Each module has it’s corresponding User Form:

Contacts User Form:

Excel CRM Contacts Form

Contacts Form

Events and Tasks share the same User Form, selecting from Event or Task will adjust the form:

Excel CRM New Event form

New Event form

Task Form:

Excel CRM New Task form

New Task form

How it works:

Each module has it’s own worksheet, that contains a table with only the most important fields from the database. The complete form has more than 20-30 fields, only 6-8 fields are displayed in the management sheet.

To Add a new Event/Task, Contact or Organization,

use the button from the A2 cell of each module sheet, this will open the module User Form.

If you click a cell from ID column, you will be able to see all data into the module User Form, this allows you to edit existing entries, or even to delete the entry.

On top of each sheet, there is a group of buttons, that will allow you to filter the data to see only data starting with that letter:

Excel CRM Filter by Letter

Filter by Letter

By default, the Contacts table filter is applied to Last Name column, Organizations will be filtered by the Organization Name and Calendar table will apply the filter to Subject column.

  Custom Reports:

If you click cell A4 on any module sheet, this will open the Custom Report Form:

Excel CRM Custom Report

Custom Report

This form is a great tool for finding a specific entry in a large database of contacts or organizations, you can search into the entire data, not only the front sheet.

Filters can be applied to multiple columns: in the image above, I applied a filter for Last Name – starts with “M”, and Office Phone – starts with “5”.

Use the “Add New Condition” button to apply filters to other columns from database.

Note: Do not apply multiple conditions to the same column (Field), only the last condition will be applied!

 Configuration Page:

If you click on the “Home Page”  button from cell A1 , on the bottom right side of the Excel CRM Home Page screen you will be able to activate the configuration sheet. (this sheet can be activated only from the Home Page, or you can simply unhide it)

Excel CRM Configuration sheet

Configuration sheet

Because the Contacts form  has 44 fields, only 8 fields are displayed into the Contacts sheet.

The configuration page will allow you to choose those 8 fields that will be displayed into the Contacts module sheet.

There are some fields that cannot be removed by default, they are needed by default module filters. Same principle applies to all modules.

Full data is stored on Full Contacts Info worksheet, which is hidden. You can unhide it to see the data, it will be hidden back the next time you apply a filter.

Excel CRM works in these Excel Versions:

Excel 2007, Excel 2010, Excel 2013, on 32 – bit or 64-bit Office versions. (Excel 2007 does not have a 64 – bit version)

Not tested on Excel 2003, but you should consider upgrading to the newer versions. Excel 2003 was great, but you are missing so many new powerful tools 🙂

Excel 2016 release is very close, new tools, new things to learn :)…

About Excel CRM Full Version:

The Full version of Excel CRM is a lot more complex, with 8 more modules, for Quotes, Invoices, Services, Products, Leads, Opportunities, Projects, Sales Orders.

The Lite version has all the forms for all modules, but they can be seen only from VB Editor, the databases and front sheets are not available.

If you need more than the free modules, or you need a special configuration, don’t hesitate to contact me to request a quote.

If you liked the Excel CRM tool, please leave a reply or share it with your friends.

Cheers,

Catalin

 

30 Comments to Excel CRM Tool for Personal Use

  1. Zubayr says:

    I need a quote on a full version please as I need it urgently

  2. Excel-CRM is a nice piece of software Caltalin.  Well written !!!

  3. Denis says:

    Quote for full version please, I am just starting to investigate CRM tools.

  4. yuki says:

    Hi, can i have the full version quote please?

  5. shabrandi says:

    Hi
    I need a quote on a full version please help me how i can get it thanks

  6. Hmuny says:

    Can I have a full version?

  7. Mehmet Ali says:

    Buna zia Catalin this very good multu mesk mult if you dont mind I need full version quote please.

  8. Louis C says:

    Hello Caltalin,

    May i have the full version quote please?

  9. Binh Binh says:

    i need fule version, quote please

  10. Dan O'Shea says:

    Please send a quote for the full version.

  11. Neao says:

    What a beautiful piece of work, may I have a full version please?

  12. Krzysztof Noga says:

    Hello, the download link does not work. Can You please check? I would also be interested in a quote for a full version of this spreadsheet.

  13. Lukasz Majerowicz says:

    First of all. This is amazing tool. I just have a quick question, I am not sure how does the “Send Notification” “Send reminder” work i set the time and date and i am just not sure how this supposed to fuction.

  14. Jeff MacDonald says:

    May I have a quote for the full version please!
    L.E.: Nevermind. I keep getting compile errors in the lite version.

  15. Hi, can i have the full version quote please? Any trial available?

  16. Daniel says:

    What is a full version cost, please send me.

  17. Ash says:

    Hi,
    I’m interested to know more about your Excel-based CRM tool. For the paid for versions, is your code locked, or would I be able to get in there to modify stuff as necessary?

    If unlocked, I’d be very keen to know your price for this tool

  18. Michel Levesque says:

    Please send me a quote for the full version.

  19. Xavier says:

    Hi Catalin
    This is such a good piece of work. Well done.
    The calendar-sheet or function in the lite version doesn’t seem to be working.
    Do I miss something?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

The Excel Learning Journey that I propose for you, is structured in such a way as to offer you the most practical way to learn Excel, free.

Start Your Free Excel Learning Journey!

Enter your email address to subscribe to this blog: