Beijing office

            If you manage databases using Excel, you will want to attend this course.   We will walk you through the steps of working with multiple workbooks and merging them into one easily managed database. If you accumulate databases on a regular basis from your sales team, research or events, you will most likely want to update your master database with information while removing all duplicate information.   The full day course will provide you with the knowledge to start using Excel to manage your information more effectively, while saving your hours of frustration.   Objectives:   This program covers the following key topic areas: • Lookup & Information Functions • Advanced List Management - merge files, workbooks, worksheets. • Trim cells, text to columns, split cell data. • Manipulating Pivot Tables - 2007 has additional features • What If Analysis - use the function to do the workings for you • Protecting & Sharing Files - security • Introduction to Macros - recording common tasks   Who should attend ?   • Marketing, Sales, HR, Accounting - team members who regularly use Excel to manage databases. Participants are encouraged to bring their own laptops with MS Excel already installed. We can arrange laptops with the MS Excel for an additional fee of 300RMB.   Facilitator: • Alistair McArthur Alistair's ten years experience in China has enabled him to attain an understanding of the China business market and develop his Chinese language skills. He has been involved in business having consulted for companies both in China and abroad, while having been the Sales and Marketing Director in IPS for over two years.   Alistair's energetic and enthusiastic style of training has entertained trainees and made him very popular with his multi-national clients. He has been involved in training companies such as Siemens, Microsoft, Grand Hyatt Hotel and the International School of Beijing.     To register, please, fill in the form and send it back to info@cameraitacina.com.

          Facing the complex, open-ended, ever-changing challenges, organizations should realize that constant, ongoing innovation is critical to stay ahead of the competition. As a business leader, how effective you are managing these business difficulties? Can you break thought patterns and think differently? This workshop will feature you how to utilize tools to spark creativity, and enable you to develop comprehensive approach to solve problems with fresh ideas and make high quality decisions. Who should attend ?   Middle to senior managers Facilitator:   • Mr. Andy Wong Mr. Lee has worked with a prestigious and highly successful multinational manufacturer for over 15 years. The Principal Consultant of Apex Management Solutions Ltd. has been engaged in business, quality, engineering and customer services improvement for more than 10 years. Additionally, he was the Chairman of the Hong Kong Leadership Training Association for the years 1994 to 1997 and has been very active in the development of leadership training for the businesses in Hong Kong.   To register, please, fill in the form and send it back to info@cameraitacina.com.

          Published research studies and practical application have proven the effectiveness of behavioral interviewing techniques. However, very few organizations do it on an expert level. This program is based on Dr. Janz`s widely distributed book on Behavior Description Interviewing and provides a set of behavioral interviewing skills as well as various kinds of skill practices. Participants shall:   • Learn to analyze the costs incurred when a wrong hiring decision is made. • Develop a fair and consistent interviewing process for selecting employees. • Prepare better job advertisements and use a variety of markets. • Develop a job analysis and position profile. • Use behavioral, achievement oriented, holistic, and situational interview questions. • Understand the basic employment and human rights laws that can affect the hiring process.   Who should attend ?   All HR functions and HR oriented people.   Facilitator:   • Mr. Andy Wong Andy Wong is a third generation Singaporean who has accumulated more than 15 years of international exposure on the senior management level. He was extensively involved in multi-industrial segments such as Chemical, Banking, Insurance, FMCG, Automobile, Hospitality and the Real Estate industry. With a strong passion for training, his classes are highly interactive, fun and informative, full of the latest information and techniques and he makes sure that every participant walks away with practical skills they can apply on the job. He is bilingual in English and Chinese, and connects well with all levels of an organization. His expertise lies in Recruitment, Business Development, Train the Trainer and Team (Leadership) Building.     To register, please, fill in the form and send it back to info@cameraitacina.com.   Tkank you for your attention   CICC