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.