+ Reply to Thread
Results 1 to 6 of 6

Long time member but haven't posted in a while

  1. #1
    Registered User
    Join Date
    01-26-2009
    Location
    seattle, washington
    MS-Off Ver
    Mac Excel 2011
    Posts
    19

    Long time member but haven't posted in a while

    Hi Guys, i registered years ago but haven't been on in a while, using Excel for Mac 2011 extensively each day & need advice from the forum to refresh my skills.

    Currently using excel as a light CRM tool for work & another CEO sheet for work related projects, calendar events & sorting my life.

    If there anybody else that uses excel as a CRM tool or project tracker or works in Seattle area, a few friends of mine are wanting to get a Excel meetup once a week.

    Glad to be part of the online community & if you needed to reach me you can private message me. Anybody that could recommend a download or be willing to share/trade templates (with data cleared of course) Message me privately... hopefully i have that turned on.

    Live in Kirkland & a coffee addict.

    I used excel for about 15 years so there are hundreds of little tweaks that I learned over time & looking forward to sharing knowledge with the group.
    Last edited by excelstone; 09-29-2014 at 04:15 PM. Reason: removed question.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello excelstone,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-26-2009
    Location
    seattle, washington
    MS-Off Ver
    Mac Excel 2011
    Posts
    19

    Re: Long time member but haven't posted in a while

    Thanks, is there a place I can go where people have some templates posted or a way to search for them?

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Long time member but haven't posted in a while

    This is my suggestion:
    I used excel as CRM. It was a nightmare to say is understatement. It will be disaster-in -waiting if you are going to share it with other users.
    In simplest term, CRM is a database. Excel is not designed for storage, particularity strings. The last time I used MS Access was 15 years, so hardly remember anything, but database is the best tool for CRM. Mind you unlikely to use it for calculation and data manipulation.
    I think there are some freebies CRM on- line.
    I used ZOHO which you can easily integrate it with excel. It was cheap, $3 per month.
    But if you really really want excel as CRM, I would use "Tables" in excel.

  5. #5
    Registered User
    Join Date
    01-26-2009
    Location
    seattle, washington
    MS-Off Ver
    Mac Excel 2011
    Posts
    19

    Re: Long time member but haven't posted in a while

    Hi AB33, oddly enough I am just getting your message & we have been using ZOHO for a few months now.

    Its been a helpful tool for centralizing our data.

    When you say integrate excel with zoho, can you give an example of what that accomplishes or what it does?

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Long time member but haven't posted in a while

    Hi Excelstone,
    Glad to know you are not using excel as CRM. I used ZOHO over 3 years ago, so my memory of the product is fading.
    I think you can built-in user defined functions in ZOHO (Formula)
    If you link ZOHO to excel, all your data are stored in ZOHO, but you can import the data in to excel and use Excel's native functions to analyse and manipulate the data. It is similar to Excel's function of data import from external source.
    I think you can also request the API from ZOHO and if you have some IT people who can easily integrate it with excel, but I am not sure if ZOHO are willing to give the API.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Long time member, first time poster...
    By drosenhe in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-21-2014, 07:50 PM
  2. Hi Member since long but posting for the first time.
    By garilou in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-06-2012, 01:42 AM
  3. Old member posting for the first time
    By garilou in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-16-2012, 01:10 AM
  4. Super-long member names for grouped fields when using GetPivotData?
    By raeldor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2011, 03:56 PM
  5. Replies: 4
    Last Post: 12-13-2005, 08:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1