Optimize Your Data Management, January 29th

Do you need to manage on a daily basis the databases of your clients, suppliers, employees or competitors? Not everyone has the advantage of having a CRM System (ie. Sales force, net suite) or Payroll system, but Excel can do this for you !

Optimizing the use of Excel functions can make your data management easier and much more effective, and will help you improve work efficiency tremendously by up to 60%.

In our Excel 2003 Advanced Training Course, we will walk you through the steps of working with multiple workbooks and merging them into one easily managed database. You will learn how to trim and apply a consistent format to data to ensure the data is presentable and can be easily read by your clients, executives and other important stake holders. You will also learn data mining techniques utilizing various tools in Excel.

Let us guide you through the database management process !

Who should attend ?
Human Resources, Sales, Marketing, Purchasing and Accounting professionals managing databases in regularly basis. *
* It is expected that participants will have an Intermediate level of Excel knowledge, such as formulas and functions, pivot tables and navigation around Excel.

Content:
- Clean up a database
- Trim cells
- Remove duplicates
- 'Look up' information
- Merge multiple workbooks or spreadsheets
- Filtering and Conditional Formatting
- Import and Export data
- Formatting tips
- Create Pivot Tables from your data
- Modify and Customize Pivot Tables
- Use Scenarios to Model Data
- Use Goal Seek and Solver
- Use Macros
- Create and modify professional Charts
- Manage data between Excel and Word
- Implement Functions and Formulas
- Use different useful hotkeys

Training Methods:
- Presentation & demonstration of applicable examples
- Facilitating individual exercises
- Presentation of Excel features and advice related to participants actual work
- Team work & experience sharing
- One-to-one assistance

Trainer:

Forrest Biswas:
Forrest has over 9 years of professional experience in the Computer Sciences and Training Industry. He is a PhD candidate at the Natural Language Processing School in Peking University as well as the champion in CCTV’s Putonghua competition.
He is expert in Programming languages and regular trainer for MS Office software, Photoshop etc. in both Chinese and English. He has conducted courses recently for Audi, New Oriental, SAS, Canadian Embassy.

DOWNLOAD REGISTRATION FORM

To register, please complete and return the Registration Form via email zhang.rose@ccifc.org or by FAX (010) 6512 1496 to the CCIFC Beijing
before Monday January 25th, 2010 6pm