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.
Date: Thursday, July 11, 2013
Time: 9.00 am > 5.00 pm
Language: English
Venue: C512, Lufthansa Center No. 50 Liangmaqiao Road, Chaoyang District Beijing
Certificate: Certificate of Completion provided to all trainees at the end of the course.
Price: Price including material and lunch.
10% discount for the second participant of the same company, 15% discount for the 3rd registration and above of the same company.
If you are interested in this training, please fill out the form attached and send it to training@europeanchamber.com.cn.
The contact number: 64622066ext.87 (Nina Jiang)
Downloads