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 to get some free advice on which one is best for your situation.

Get More Great Tips & Answers – Subscribe ➜

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

Tell Us Your Business Pains and Get Your First Three Action Steps Here ➜

Want a Question Answered or Want to Sponsor a Video?
Support the education of new and growing business owners with your donations here ➜

Join the conversation in our Closed FB Group. Request an Invite Here ➜

Follow, Friend, Like or Be a Contributor
My Clone Solution Website
Brook Borup; Speaker, Educator, Implementor

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.