Debbie Mayo Smith, International Motivational Speaker
Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

Posts Tagged ‘excel’

Five strategies for better profit from your database

Wednesday, August 15th, 2012

1. Never let a viable prospect go You spent time and money through networking, good customer service, advertising and website development to get prospective customers to your figurative door. Don’t waste your money or time spent. Establish a communication stream to keep in contact until they are ready to do business or refer. 2. Excel is Magic It doesn’t matter what database software you use to store your information because it’s simple to bring it into Excel to then manipulate, clean, de-duplicate and add to it in seconds flat. 3. Plan for the future today If targeting improves success – do you have enough information to do so? Have you ever stopped to contemplate what new products, services, customer service initiatives you’d like to do over the next few years? A new branch or store? What about additional staff? Will you ever need to know or monitor their productivity or their contribution to business? If so how will you measure it? What fields would you need? Phone numbers.  Are you consistently collecting mobile phone numbers so you can do sms messaging in the future? 4. Categories not columns The last thing you want to do is work with an endless line up of columns. Don’t set up separate columns for clients, prospects, old clients, suppliers. Instead have one column called client type and have different Categories (or variables) you enter into the one column, being client, old client, prospect, supplier. 5. Treat your business referrers well Do you have a distinct communication, thank you and reward plan for those business colleagues that refer business your way? Why not? A suggestion to help them could be a tip newsletter about how to improve their business success. Why not create a recurring reminder to prompt you every few months to telephone for a chat. The more thought you put into developing and using your database, the more you’ll be rewarded.

Video: Automatically Enter Time Or Dates Into Excel Spreadsheet Cells

Tuesday, February 17th, 2009

Search

 Subscribe to blog

Free Quick Tips
View and sign up for Debbie's free monthly newsletter now!

Call Debbie Now!
64 (9) 575-5359 NZ
61 (3) 9005 7563 Melbourne
61 (2) 8005 7551 Sydney

Debbie@successis.co.nz


Books

Marketing in Today's Wired World

Marketing in Today's Wired World alerts you to the many profitable and clever ways you can use email, txt, video and audio messages to boost revenues, recruit new business, cut costs, improve customer service and leapfrog in front of your competition.
Read more...

101 Quick Tips for Google and Email
101 Outlook and Google Tips Debbie's years of experience working with email and Google are packed into this easy to read #1 bestselling book.
Read more...

101 Quick Tips: Create a Great Customer Experience
101 Customer Experience Tips do you want more sales, referrals and repeat business? Then you need this book! You won't want to miss these 101 tips to place your head and shoulders above the crowd to build customer loyalty, word of mouth, and profits.
Read more...

101 Quick Tips: Surviving the Kids
101 Balancing Tips with nine children between them and busy careers, let Debbie and Mary Lambie use their experience to make this practical little book a goldmine of solutions for you.
Read more...

Conquer Your Email Overload Superb Tips and Tricks For Busy People
Save hours a week using clever, timesaving 'how-to' solutions to the top problems you have using email, your calendar, address books/contacts.
Read more...