Dear Members and Friends,
The European Union Chamber of Commerce in China Shenyang Chapter, together with Hong Kong Chamber of Commerce in China-Shenyang ,Eddic(china) training center, is thrilled to invite you to the BETTER MANAGE YOUR DATA-EXCEL ANALYSIS TRAINING from 13:30 to 18:30,18th May, 2017 at Sofitel Shenyang Lido in Chinese.
中国欧盟商会沈阳分会,中国香港(地区)商会-沈阳与易迪思(中国)培训中心携手共同邀请您参加于2017年5月18日, 13:30-18:30,在沈阳丽都索菲特酒店举办的更好的管理你的数据-Excel数据处理与统计技巧研讨会。
Seminar Objective:Beginning a new job that needs advanced Excel skills? This is an activity-based workshop to cover advanced Excel features and commands for Excel users who wish to deepen their knowledge of this business application.
研讨会介绍:您是否面临这样的挑战:需要掌握更高级的Excel 应用技巧,以应对一项新的工作任务?大量的动手实践活动,丰富的实战经验技巧, 涵盖多项Excel 关键技术。没错!这就是本课程的魅力所在,帮助参与者拓展Excel惯有的认识和了解,更上一层楼。
Audience:For thepeole who need to improve the excel using level, improve the efficiency of data processing.
课程受众:本课程适合有需要系统提升Excel使用水平,提高数据处理效率的Excel用户
Content of the seminar:
1. Data collection and sorting
a) Data collection
b) Standard the manual input data
c) Multiple sources of data import
d) The processing of unqualified data(Data validation)
e) The processing of repeated data
2. Data analysis faster
a) Summary data fast with subtotals
b) Use the Pivot Table to build report
3. Statistical analysis and report making with function
a) The necessary knowledge of using function
b) The learning of popular function
4. The present of data information
a) Professional business chart
b) The popular chart types and tips
c) The senior skills of chart application
5. Excel reports preparation
a) The publish settings of electronic version
研讨会内容:
1. 数据的收集和整理
b) 数据的收集
c) 控制手工输入数据的合规性
d) 多种来源数据导入
e) 处理不合格的数据格式(数据有效性)
f) 重复数据的处理
2. 数据的快速统计与分析
a) 利用分类汇总快速统计数据
b) 灵活运用数据透视表构建报表
3. 利用函数进行统计分析和报表制作
a) 函数运用的必要准备知识
b) 常用函数学习
4. 数据信息的呈现
a) 专业化的商务图表应用
b) 常用图表类型与制作技巧
c) 图表应用高级技巧
5. Excel报表的发布准备
a) 电子版本的发布设置
Special Note: Please bring your own computer, so that you can better use the tips!
特别提醒:请自带电脑,在动手联系环节实际操作可以让您更好掌握研讨内容!
Agenda日程:
13:30-14:00 Registration 注册登记
14:00-15:20 Part A A部分
15:20-15:40 Coffee break 茶歇
15:40-17:00 Part B B部分
17:00-18:30 Networking light buffet 社交简餐
Language语言: Chinese中文
Fee费用: Member:RMB 100 | Non-Member: RMB 150 会员100元 | 非会员150元
Venue: 4th floor, Sofitel Shenyang Lido 丽都索菲特酒店4楼
Address地址: No.386,Qingnian Street, Heping District, Shenyang 沈阳市和平区青年大街386号
Registration:
Please fill in the entry form below and send it to us via E-mail:
shenyang@europeanchamber.com.cn before May 16th, 2017
Company
|
|
Name
|
|
Gender
|
|
Nationality
|
|
Position
|
|
Phone No.
|
|
E-mail
|
|
注册:请将您的信息填到上方的表格,与2017年5月16日前,发邮件至shenyang@europeanchamber.com.cn
Please note: In case you registered but cannot attend, please remember to cancel your reservation 24 hours in advance, otherwise a no-show fee will be applied and you will be invoiced for the event.
请注意:如果您在注册后,不能参与活动,请于活动开始24小时前取消您的注册。如果您没有取消,我们会将发票邮寄给您,不退回费用。
European Union Chamber of Commerce in China,Shenyang Chapter