HIDDEN SECRETS IN DATA ANALYSIS WITH EXCEL
Achieve breakthrough data management 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 are unable to do this in less than a minute, attending this course would then be extremely valuable for you.

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.

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

Translating Raw Data Into Useful Business Information

Select all records that meet a certain criteria (such as blank cells, contains conditional formats, visible rows, etc) at once using a simple and yey rarely explored function in Excel.

Build formulas that can intelligently and accurately:
>> Retrieve the information from the dataase,
>> Merge records from two lists together,
>> Remove Duplicates from the list, etc.

Analyze data contained within an Excel workbook using pivot table, a popular and powerful business intelligence tool provided by Microsoft®
Excel. >> Summarize the data using Pivot Table >> Create a new view with the mouse

Learn how to retrieve office database records without having to do any export and import, and get up to date reports at regular interval.

Learn how to automate work processes even when having ZERO knowledge on Macro programming.

Apply all the following Excel functions and formulas in the case scenarios

1. Working with Date Functions
2. Working with Sub-Total Functions
3. Working with IF function
4. Using Auto filters
5. Using Goto
6. Counting records based on criteria
7. Getting relevant data from a cell
8. Merging data from two list of records
9. Using Pivot Table
10. Using Pivot Chart
11. MS Query
12. Handle errors in formulas
13. Introduction to Macro Programming

Business managers and executives, CFOs, Financial Analysts and those who are involved in the analysis of business data.

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 (Excel 2003 and below), course details (Excel 2007)and Registration Form Now!

At the end of the course, we hope you can be as excited as Bilal.

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.