CUSTOMER ANALYSIS WITH EXCEL
Maximise your sales potential through constant customer contact

It is a well known fact that maintaining an existing customer is 5 times less expensive than acquiring a new one. Keeping in touch with your existing customers is the key to make your existing customers who have a positive buying experience come back to the store to buy from you again. But many companies are not keeping in touch with their customers, thinking that they have to spend tens of thousands of dollars, buying expensive software or out-sourcing the process, to do that. Unknown to these companies, the tool to keep in touch with their customers is right in their computers and it cost them almost nothing. Using Microsoft® Excel, they can easily keep records of their customer details and analyse their purchases. If used with Microsoft® Outlook and Microsoft® Words, these companies can even customize emails and personalized sales letters to share about the products their customers have purchased and also update them on new product launches. Find out how you can increase your sales at minimal cost, and sign up for our Customer Database Management with Excel Course now!

Through the process of using Excel functions and formula, you will learn how to:

• keep in touch with your customers
• effectively manage your customer database
• profile your customers
• analyse your customers' purchases
• identify your top customers

1. Classify your customers by age groups if you only have their birth dates,
2. Identify the year of birth of your customers,
3. Calculate the age of your customers accurately,
4. Find customers that meet your marketing criteria,
5. Count the number of customers who fall into your targeted customer segment.
6. Count the number of your existing customers who are still buying from you and monitor the quantity purchased,
7. Retrieve your customers' surnames (of varying length) from their full names,
8. Merging customers' purchases with their profile,
9. Removing duplicates in your customer database,
10. Real time monitoring of customers' purchases,
11. Consolidating sales from multiple locations,
12. rofiling and analyzing customers purchases using charts

This course is specially tailored for business managers and executives working in restaurants, clubs, manufacturers offering product warranty, department stores, retailers offering loyalty/discount cards, insurance agents, property agents, and others who need to analyze or profile their customers.

Now, before you sign up for the course, it is important to you read this. The course is not for everyone. Do not attend the course if you do not have at least 2 years of experience working with Excel. And to make sure that you are able to benefit from the course, you must answer YES to the following questions:

• I know how to format the cells?
• I know how to create a simple template?
• I can perform summation using worksheet functions?
• I can insert and delete rows and columns?
• I can perform Copy and Paste in Excel?
• I know how to sort data in Excel.

If your answers to the questions are all "Yes", download the course details and Registration Form Now!

Computers and Course materials will be provided by everydayExcel Business Lab Pte Ltd.

1. Inhouse courses are for companies who have about 10 participants and can choose to use their own resources (computer lab) for the training.
2. Inhouse courses also allows participants to share more openly about their Excel related problems since it is conducted among their own colleagues.
3. Inhouse courses can also be customised to cater to the needs of participants.

everydayExcel trainers are all experts in spreadsheets and databases. They are specially hand-picked by the Chief Trainer, Jason Khoo, based on their experiences in training and the business knowledge they possess. Jason has worked in local listed companies and foreign MNCs managing the companies' budgeting process and developed business models for forecasting. He was also a financial counsel for a Fortune 500 company's business unit which generated a total revenue of more than S$100 million per annum.

everydayExcel has helped many companies save thousands of dollars by providing simple and yet powerful business solutions through the use of Microsoft® Excel. Examples of such solutions include budget planning and forecasting, customer segmentation program, personalized email broadcast to targeted customers, and sales lead generation program (mini CRM), etc.