Home

Excel: Data Analysis

Course Details
Date: 
Wednesday, February 15, 2012
Time: 
9:00am to 5:00pm
Investment: 
1,800 RMB per Participant
Location: 

 

CCIFC Beijing, Conference Room
Office Unit C512, Floor 5th, Beijing Lufthansa Center
No. 50 Liangmaqiao Road, Chaoyang District
Beijing 100125
Course Description
Why should you attend?: 

If you manage databases using Excel, you will want to attend this course. IPS 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 you hours of frustration.

Who should attend?: 

Marketing, Sales, HR, Accounting - team members who regularly use Excel to manage databases.

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
  • What If Analysis - use the function to do the workings for you
  • Protecting & Sharing Files - security
  • Introduction to Macros - recording common tasks

Participants are encouraged to bring their own laptops with Excel already installed. We can arrange laptops with the installation of Excel for an additional fee of 200 RMB.

Trainer: 
Alistair McArthur
Contact: 

Sophia Wei

swei@discoverips.com

Excel: Data Analysis
PowerPoint
Word
Microsoft Project 2003/2007
Outlook
Excel - Managing Databases
Presenting With PowerPoint
Excel: Data Analysis
Excel: Data Analysis
Presentations: Presenting with Powerpoint

Discoverips.com