everydayExcel Business Lab Logo

HOME
TRAINING PROGRAMS
TESTIMONIES
ARTICLES
FAQ
TRAINING ROOMS
VACANCIES
CONTACT US
MEMBER LOGIN

SALES PERFORMANCE ANALYTICS WITH EXCEL
Achieve breakthrough performance in Sales/ Marketing like never before

With the advancement in technology, companies are capturing more and more data about their customers, including their contacts, purchasing patterns, etc. And there arises a need to analyse and transform the data into information which could be used to generate sales. While the IT departments are capable of capturing the information, majority of them are not able to sieve the information based on the business needs and requirements of the company. And you are left on your own to figure out how you should make use of this data for your marketing purpose.

In most cases, you are likely to make use of common desktop applications like MS Excel to analyse the data and to present the summary to the management. Depending on how conversant you are in using Excel, you could be spending minutes or days to get the same information. Being able to exploit the power of Excel would definitely help you to progress beyond your current level of work efficiency and productivity.

If you are not sure if this is a course you should attend, simply click here to find out if you could get the correct information asked for in 1 minute.  If you cannot, attending this course will then be absolutely valuable for you.

WORKSHOP OBJECTIVES

Taking a hands-on approach and making use of common business decision-making scenarios, participants will:

  • learn about the especially useful built-in functions in Excel; and
  • apply the functions learnt in business case studies.

WORKSHOP OUTLINE

Through the use of business scenarios, participants will learn how to exploit the Excel formulas in a creative way to achieve the business objectives.

Case 1 - Translating Data

Case 2 - Selecting Records

Case 3 - Building Complex Formulas

Case 4 - Analyzing Data

Case 5 - Retrieving Databases

Case 6 - Dynamic Charts

Case 7 - Automating Processes

Detailed Course Outline for Sales Performance Analytics with Excel

WHO SHOULD ATTEND

Managers, Marketers, Sales Professionals, Market Support Team, Executives and anyone who is involved in managing and analysing marketing and promotional data.

PRE-REQUISITE

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, please answer the following questions:

  • Do you know how to format the cells?
  • Do you know how to create a simple template?
  • Do you know how to perform summation using worksheet functions?
  • Do you know how to insert and delete rows and columns?
  • Perform Copy and Paste in Excel?

If the answers to the questions are mostly "Yes", download the course details and registration form Now!

Testimonies from our courses' participants

Photos of our Participants

WORKSHOP SCHEDULE

The course is 2 days long. After the first day, participants are given about one week to put what they have learnt to practise. They are encouraged to submit their problems in using Excel to us so that we could provide the solution and share it with the rest of the participants.

COURSE FEES

Price:$600 per pax
Computers and Course materials will be provided by everydayExcel Business Lab Pte Ltd.

Course Dates

Drop us an email at enquiry@synergyworks.com.sg and we will keep you updated on our new course date.

If you wish to be informed when we organise another of our public courses or would like to find out more about our inhouse course, drop us an email at enquiry@synergyworks.com.sg. Given below are the benefits of an inhouse course:

  1. Inhouse courses are for companies who have more than 6 participants and would like 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.

»Download Course Details and Registration form Now!

VENUE

10 Anson Road #26-02A
International Plaza
Singapore 077903

ABOUT THE TRAINER

Jason Khoo is the founder of SynergyWorks, which specialises in spreadsheets and databases. He has helped companies draw out valuable information from databases from existing systems and saved these companies thousands of dollars from purchasing new systems by providing solutions using existing PC applications such as MS Office. Examples of such solutions are customer segmentation program, personalised email broadcast to targeted customers, sales lead generation program (mini CRM) etc.

Prior to setting up his own company, Jason has worked in local listed companies and foreign MNCs supporting the marketers in analysing their marketing plans and providing quality information for business decision-making. He was also a financial controller in a Fortune 500 company for a business unit which generates a total revenue of more than S$100 million per annum.

He has also conducted customised in-house Excel training for companies like Discovery Asia, Eltra Aeronactics, etc.

Keep me updated
on your course dates!
:
:
Remember: Your privacy is safe and you may stop further mailings at any time.

PS: We need you to click on the link in our confirmation email to confirm your name and email address so we can verify you are a real person. Please look out for it.


Keep me informed
of your training in Malaysia!
:
:
Remember: Your privacy is safe and you may stop further mailings at any time.

PS: We need you to click on the link in our confirmation email to confirm your name and email address so we can verify you are a real person. Please look out for it.