How to Setup Your Contact Data in Excel… CRM Here We Come! [Video]

"How to setup contract data in excel" in white text and woman using her laptop while wearing a pink long-sleeve shirt

Welcome to in the Trenches MBA! In this video we are going to talk about how to organize your contact data in excel so you can put it to work for you. Our lists are the backbone of any business are you using yours effectively? Here is the first step.

If you need more help after this video feel free to go here https://bit.ly/3tasksfree to get some free advice on which one is best for your situation.

Get More Great Tips & Answers – Subscribe ➜ https://bit.ly/mcssubyoutube

Share this Video on Facebook, Your Blog, Websites and More!

https://youtu.be/rhLj0ehvR9g

Tell Us Your Business Pains and Get Your First Three Action Steps Here ➜ https://bit.ly/3tasksfree

Want a Question Answered or Want to Sponsor a Video?
Support the education of new and growing business owners with your donations here ➜ https://www.patreon.com/ittmba

Join the conversation in our Closed FB Group. Request an Invite Here ➜ https://bit.ly/InsiderInvite

Follow, Friend, Like or Be a Contributor
My Clone Solution Website https://myclonesolution.com
Brook Borup; Speaker, Educator, Implementor https://brookborup.com
https://twitter.com/BrookBorup
https://www.facebook.com/myclonesolution
https://plus.google.com/+MyCloneSolutionTampa/
https://www.linkedin.com/brookborup
======================================================

Where Does Contact Data Come From?

Business Cards (Networking) (0:25)

• Separate all your columns

Email Lists (Offline and Online) (0:32)

• Save email address to an address book
• Capture info from signature lines
• Website forms and opt-in opportunities

Client Lists (0:40)

• Targeting for more recurring services
• Notes about services purchased
• Notes about client experience

All This Contact Data in One Place…(0:58)

Start with Excel While You “Get Cleaned Up”
– Standard Columns (across the top)
• First name
• Last Name
• Company Name
• Title
• Phone
• Cell
• Email
• Address
• City
• State
• Zip
• Alternate Email
• Where did you meet
• Birthday
• Products Purchased
• Payment Method
• Favorites
• Social Media Links
• Assistant Name
• What other contact data information do you collect? Make a Column for that
======================================================

Ready To Get More Done?

If getting more done in your day is a priority and you just need guidance, strategy, or advise in a group setting in order to move the needle then our Small Business Growth Community is for you.

Need One on One Attention?

That is possible too, schedule a FREE Ask Anything Call Here.