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.

 

 

To register, please, fill in the form and send it back to info@cameraitacina.com.

Venue: 
C512, Lufthansa Center No. 50 Liangmaqiao Road, Chaoyang District Beijing
Rundown: 
9.00 am to 5.00 pm (1hour lunch break)
Cancellation: 
• Cancellation requests must be confirmed by Email to the CICC: info@cameraitacina.com
RSVP: 
Registration must be send back to info@cameraitacina.com
Invitation: 
The China Italy Chamber of Commerce, together with the French Chamber of Commerce in China, the European Union Chamber of Commerce and Industry in China, the German Chamber of Commerce in China, the Swiss Chinese Chamber of Commerce in China, the Spanish Chamber of Commerce in China and the Benelux Chamber of Commerce in China is glad to invite you to the French Chamber`s Training
Event language: 
English
Organizer: 
CICC - Events
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.
Timing: 

Copyright ©2016 by China-Italy Chamber of Commerce
Website Maintenance China | flow.asia
京ICP备06006969号-1

加入中国意大利商会

成为我们超过500个意大利及外国企业这个网络体系中的一员. 通过赞助商、合作以及在我们的官方网站上投放广告从而使您获得更高的知名度。

了解更多