Excel: Database Management

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:
Tuesday, November 19, 2013

Time:
9.00 am > 5.00 pm
(1hour lunch break)

Price:
1500 RMB / Members
1800 RMB / Non members

* 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.

Venue:
C512, Lufthansa Center No. 50 Liangmaqiao Road, Chaoyang District Beijing

Language:
English

Registration : if you are interested in this training, please fill out the registration form and send it back to training@europeanchamber.com.cn

Contact Number: 010 6462 2066 ext. 60( Clinda Zeng)

Downloads

Related

Contact