Full-day Training (in Chinese/中文): 更好的管理你的数据——Excel 数据处理与统计技巧课程 / Better manage your data——Excel data analysis skill training Go back »
-
Time2016-09-28 | 09:00 - 17:00
-
Venue:The European Chamber Shanghai Office, Unit 2204
-
Address:
-
Fee:Members: 2000 RMB |
Non Members: 3000 RMB
We would love to hear your feedback, and it just takes a minute.
主要内容 Main Content
- 合理的 Excel 数据结构设计
- 数据的整理和分析技巧(含数据透视和常用函数)
- 利用图表有效呈现数据
- 数据的安全和保护方法 软件版本为 Office 2010 或 2007
- Reasonable design of Excel data structure
- Data collection and analysis skills(Containing PivotTable and popular function)
- Effective presentation data with chart
- The method of data security and protection
- Software version required:Office 2010 or 2007
This training will be delivered in Chinese.
课程受众 Audience
本课程适合有需要系统提升 Excel 使用水平,提高数据处理效率的 Excel 用户(中高级水平 培训)
For the People who need to improve the Excel using level, improve the efficiency of data processing.(Mid-Senior course)
课程目标 Course Objective
1. 掌握数据分析中的理想数据源格式,改变建立数据表格的错误习惯。
2. 学习并掌握能提升数据处理效率的实用功能并掌握操作技巧。
3. 掌握快速进行报表制作的重要工具和常用数据分析函数,提高数 据统计分析效率。
4. 找到适合自己的数据呈现方式和表现手法,突出数据信息,提高 工作报表质量。
1. Master the proposed data source formats in data processing,correct the error habit of establishing the data form.
2. Learn and master the practical function of enhance the efficiency of processing data, and operation skills.
3. Master the tools of fast making report and the popular data analysis function, improve the efficiency of data analysis.
4. Find the suitable data presentation and performance practices, highlighting the information of data, improve the work reports quality.
课程大纲 Course Agenda
1 数据处理基本流程和注意事项
1.1 工作中的数据处理流程
1.2 数据处理的必要前提
1 The basic data processing flow and the notice
1.1 The data processing flow in the work
1.2 The precondition-prerequisite of data processing
2 数据的收集和整理
2.1 数据的收集
2.1.1 多种来源导入数据
2.1.2 控制手工输入数据的合规性
2.2 数据的整理
2.2.1 处理不合格的数据格式(数据有效性)
2.2.2 重复数据的处理
2.3 常用数据处理工具
2.3.1 排序的特殊应用
2.3.2 筛选的高级应用
2 Data collection and sorting
2.1 Data collection
2.1.1 Multiple sources of data import
2.1.2 Standard the manual input data
2.2 The sorting of the data
2.2.1 The processing of unqualified data(Data validation)
2.2.2 The processing of repeated data
2.3 Popular tools of data processing
2.3.1 The special usage of sort
2.3.2 The advanced usage of filter
3 数据的快速统计与分析
3.1 利用分类汇总快速统计数据
3.2 灵活运用数据透视表构建报表
3.2.1 数据透视的构建前提
3.2.2 数据透视表的构建方法和技巧
3.2.3 数据透视表的调整和美化
3 Data analysis faster
3.1 Summary data fast with subtotals
3.2 Use the PivotTable to build report
3.2.1 The premise of PivotTable
3.2.2 PivotTable getting start
3.2.3 The adjustment and beautification of PivotTable
4 利用函数进行统计分析和报表制作
4.1 函数运用的必要准备知识
4.2 常用函数的学习
4.2.1 统计函数的学习和应用(SUM、SUMIF、COUNT、COUNTIF、
AVERAGE、AVERAGEIF 等)
4.2.2 查找引用函数的学习和应用(VLOOKUP 等)
4.2.3 逻辑函数的学习和应用(IF、AND、OR 等)
4.3 利用函数综合解决实际问题——案例学习
4.4 函数常见错误的排除
4 Statistical analysis and report making with function
4.1 The necessary knowledge of using function
4.2 The learning of popular function
4.2.1 The statistical function ( SUM, SUMIF, COUNT, COUNTIF, AVERAG,AVERAGEIF…)
4.2.2 The lookup function(VLOOKUP…)
4.2.3 The logical function(IF, AND, OR…)
4.3 Use the different functions together to solve practical problems——case study
4.4 Troubleshooting for function error
5 数据信息的呈现
5.1 专业化的商务图表应用
5.1.1 常用图表类型与制作技巧
5.1.2 图表的布局与美化
5.1.3 图表应用高级技巧
5.2 使用条件格式呈现数据信息
5.2.1 自动套用条件格式
5.2.2 自定义你的条件格式
5 The present of data information
5.1 Professional business chart
5.1.1 The popular chart types and tips
5.1.2 The layout and beautify of chart
5.1.3 The senior skills of chart application
5.2 Use conditional formatting presenting data information
5.2.1 Use default conditional formatting
5.2.2 Use a custom conditional formatting
6 Excel 报表的发布准备
6.1 Excel 报表排版技巧
6.1.1 表内超链接的使用
6.1.2 排版技巧
6.2 电子版本的发布设置
6.2.1 保护报表不被更改
6.2.2 设置允许编辑区域
6 Excel reports preparation
6.1 The Excel report typesetting skills
6.1.1 Use hyperlinks in the table
6.1.2 Typesetting skills
6.2 The publish settings of electronic version
6.2.1 Protect the report not to be changed
6.2.2 Set the editing area
Payment:
You can pay at the day of the event using cash or local debit/credit cards. The European Chamber can give you an official fapiao for amount exceeding 200 RMB, and this will be sent to you via courier a few days after the event.
Terms & Conditions
Trainings have very limited seating so to ensure your attendance we encourage advance online registration and payment. We cannot guarantee entry to anyone not registered in advance.
The training is held in Chinese.
Cancellation Policy
If you cannot attend the training for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.
To cancel you can: 1) email yangzhao@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.
Speakers
Mr. Zheng Xue
Mr. Zheng Xue
• 易迪思金牌讲师
• 数据分析与数据思维培训师
• 连续 9 年微软最有价值专家
• 清华大学 MBA 课堂外聘讲师
• 曾经 5 年时间为微软公司的员工培训数据应用技能
授课特点
• 教学思路:逻辑清晰,善于引导学员独立思考和实践,全面调动学员投入热情
• 内容诠释:深入浅出,注重理论与实际工作的结合,让让学员学有所得
• 授课风格:生动灵活,幽默诙谐,使学员寓教于乐
主讲课程
PowerPoint 商务设计与展示系列
• PPT 轻松操作完美展示技巧
• PPT 设计排版进阶之路
• PPT 呈现力提升实战技巧
• 工作型 PPT 构思与设计实践
• PPT 演说技巧
Excel 数据高效处理系列
• 数据处理与数据分析技巧
• 函数学习从入门到精通
• 自动化数据报表设计与实践
• 数据模型设计与数据预测
其他
• Word 文档处理与排版
• Outlook 邮件与日程管理
• Visio 高端商务绘图系列
• Tsinghua University special trainer for MBA in the series courses of professional quality
• Microsoft Most Valuable Professional (MVP) for 6 consecutive years, contributed to enhance office efficiency and skills sharing
• Microsoft Certified Professional (MCP) since 2009, Microsoft Certi- fied for IT Professional (MCITP)
• KingSoft WPS certified Trainer, once participated in KingSoft’s WPS Enterprise training specialist program
Teaching characteristics
• Training Thought: clear logic; encouraging independent thinking and work practice; motivating trainees in high spirit.
• Training Content: focusing on putting theory into practice to make trainee gain what they want easily but deeply.
• Training Style: making trainee feel the joy of training vividly and hu- morously.
Main courses
PowerPoint Design and Presentation for Business Series
• PowerPoint easy making and perfect presenting
• Being a Master on Composing and Designing PowerPoint
• Enhancing PowerPoint Presenting Practice
• Work-oriented PowerPoint Design practice
• PowerPoint Presentation Skills
Excel dadta processing efficiently series
• Data processing and analyzing skills
• Functions learning from entry to master
• Design and practice of automatic data report
• Data Model Design and Prediction
Others
• Word Document Processing and Typesetting
• Outlook: Email and Schedule Management
• Visio Advanced Picturing Series
行业经历
• 8年专业培训师经验,曾服务近百家国内外知名企业、国家机关单位及高等学府。每年授课超过百场,受到各级学员的一致好评与爱戴。
• 曾担任微软内部员工 Office 办公技能培训项目培训师及项目负责人,从Office 软件制作厂商系统 Office 的应用价值和使用技巧。对于 Office 办公软件培训有丰富的课程设计及授课经验,擅长为企业定制培训课程和搭建培训体系。
• 毕业于北京师范大学,在校期间曾修习教育学、心理学课程,在教育培训方面有专业的知识背景,在课程体系设计、课程内容讲授方面有自己的独到见解。
参与项目
• 曾为国内外机关、企事业单位及院校进行培训,每年百余场。
• 清华大学 MBA 课程外聘培训师,在清华大学 MBA 班开课4年。
• 作为项目负责人及培训师为微软内部员工 Office 培训项目5年时间。
• 国家教育部“教师微课设计与制作”项目特邀培训师,培训教师近千人。
Experience related
• Having more than 8 years’ experience as a professional trainer. Ser- viced for about hundreds of famous domestic and overseas corpora- tions, government offices as well as universities. And delivered more than hundreds of classes annually, meanwhile have received high evaluations from all trainees.
• Acted as a trainer and leader of office skills program for Microsoft’s employees, delivering the Microsoft Office‘s application skills and us- ing values. He made a great contribution to design the exact training course with perfect training system for enterprises professionally due to his rich experiences in course designing and teaching.
• Graduated from Beijing Normal University, during the period of university, he had studied courses of pedagogy, psychology, own- ing professional knowledge background in education and training, Moreover, he had his own unique insights in terms of curriculum de- sign and teaching contents.
Programs participated
• Serviced for domestic and overseas offices, state offices and univer- sities with hundreds classes a year.
• Tsinghua University special trainer for MBA since 2011.
• Acted as a trainer and its leader of office skills program for Micro- soft’s staff inside for 5 years.
• Being a guest trainer invited by national education department
• for Teacher’s micro-class design and presentation program including nearly a thousand trainees.
服务客户 Customers Serviced
机械&制造 / Machinery and Manufacture
PTC 美国参数技术公司、阿尔斯通、山特维克、基伊埃机械设备、艾默生、横河电机、大众、雪铁龙、日产Parametric Technology Corporation, Alstom, Sandvik Group, GEA Mechanical Equipment, Emerson,
Yokogawa Electric Corporation, Tianjin Volkswagen, Citroen, NISSAN
能源 & 化工 / Energy and Chemical Industry
中国石油、中国石化、中国海洋石油、国家电网、美国国民油井华高公司、天时石油设备、金风电力、PPG涂料、阿克苏诺贝尔PetroChina, Sinopec, CNOOC Ltd., State Grid Corporation of China(SGCC), National Oilwell Varco, TSC Group,
Xinjiang Goldwind Sci & Tech Co.,Ltd., PPG Industries, Akzo Nobel N.V
互联网 & IT & 通讯 & 电子 / Internet, IT, Comunication and Electronic Industry
亚马逊、百度、微软、思科、北京金山软件、金雅拓、中国电信、中国联通、卓望信息科技、NEC、松下、LG中国
Amazon, Baidu, Microsoft, Cisco, Beijing KingSoft, Gemalto,China Telecom, China Unicom, ASPire information technology, NEC, Panasonic, LG Electronics(China)
金融 & 保险 / Finance and Insurance
中国平安、新华保险、光大永明、宜信、首信易智付、达信
Ping An Insurance (Group) Company of China, Ltd, New China Life Insurance Company Ltd,
Sun Life Everbrightlife Insurance Company Ltd, CreditEase, PayEase, Marsh
医疗 & 制药 / Medicare and Pharmacy
赛诺菲安万特、武田药品、萌蒂制药、施为亚、同仁堂
Sanofi-Aventis, Takeda Pharmaceutical, Mundipharma, Servier, Beijing TongRenTang
广告 & 媒体 / Advertisement and Media
奥美广告、智威汤逊、电通广告、中央电视台、北京电视台
Ogilvy & Mather Advertising, J. Walter Thompson, Beijing Dentsu, CCTV, Beijing TV
教育 & 科研 / Education and Research
清华大学、中国农业大学、天津大学、北京工业大学、北京教师进修中心、中国科学院、中国互联网信息中心
Tsinghua University, China Agricultural University, Tianjin University, Beijing University of Technology, Chinese Academy of Sciences, CNNIC
地产 / Estate
新世界地产、凯德地产、华夏幸福基业New World Realty Ltd, Capitaland, CFLD
其他 / Others
美国商会、欧盟商会、德国商会、北京 HR 协会、天津人力资源俱乐部
American Chamber of Commerce, European Union Chamber of Commerce, German Chamber of Commerce, Beijing association of HR, Tianjin HR club