Course benefits 课程收益：

1. Grasp the two data models in work; 理解工作中的两大数据模型；
2. Improve the efficiency of sorting out non-standard data; 数据的快速整理，极大提高整理不规范数据的效率; 
3. Improve the ability of data analysis, respond to the data demand of the superior quickly; 快速提高数据分析的能力，快速响应上级提出的数据需求；
4. Chart making and beautification, making professional business charts and dynamic board of key indicators. 图表制作与美化，快速制作专业美观的商务图表，制作关键指标动态看板。  

Course Outline 课程内容

August 12th 8月12日：

1. How to manage the data effectively?【思维篇】怎样才能有效管理工作中的数据？ 

• Grasp the two key models in data analysis 搞懂两大数据模型是数据分析的关键 
• Distinguish four data types to avoid confusion 分清4种数据类型才能避免手忙脚乱 
• Key to efficiency：The type of file 文件类型决定了效率 
• Key to success：Clear analysis process 清楚分析流程才能胸有成竹 

2. Sort nonstandard data quickly【整理篇】快速整理工作中的不规范数据  

• How to merge data from multiple tables quickly? 如何快速合并多个表格的数据？
• How to convert uncountable numbers quickly? 如何快速转换不可计算的数字？
• How to extract numbers from text quickly? 如何从文本中快速提取数字？
• How to avoid collecting wrong data? 如何避免收集到错误数据? 
• How to process large amounts of data with excel? 如何用Excel处理大量数据？

August 13th 8月13日 ：

3. How to make agile analysis of data?【分析篇】如何做到数据的敏捷分析？

• Let PivotTable update data source dynamically 让透视表动态更新数据源 
• Quick analysis 快速搞定各种分析 
• Use slicers to associate multiple PivotTables 切片器关联多个透视表
• What is a data model? 什么是数据模型？
• Building relationships and measuring 建立关系与度量 
• Excel big data analysis Excel大数据分析 

4. How to make the chart to express the purpose directly?【图表篇】怎样让图表直观表达目的？

• How to choose the right chart to express opinions? 如何选择合适的图表表达观点？
• How to make professional charts? 如何制作专业的图表？
• How to make a double coordinate chart? 如何制作双坐标图表？
• How to make dynamic charts? 如何做出动态图表？
• How to make multiple charts related? 如何让多个图表进行关联？
• How to make an interactive dashboard? 如何做出交互式仪表板？

课程安排 Agenda 

August 12th & 13th, 13:30-16:30 
8月12日-13日, 13:30-16:30

Language 语言: 中文/Chinese

Payment付款方式：报名后请将培训费汇款至以下账户，并在银行转账单上附注BJ20200812 或 联系商会工作人员付费

A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
北京市朝阳区新源南路6号京城大厦 

Cancellation 取消政策:

If you cannot attend an event for which you have registered, please cancel your registration no later than 24 hours prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be fully charged for event costs. You may cancel online or notify the contact person in the European Chamber.如果您不能参加已注册过的活动，请至少在活动开始72小时之前取消您的注册。若您未能及时地通知我们，我们将收取您相应的活动费用。您可以联系工作人员取消，也可以网上自行取消。

Speakers

Mr. Yongqian Bai

Trainer EDDIC

Mr. Yongqian Bai

Trainer EDDIC

View speaker details

Excel专职讲师
9年企业Excel内训经验
原知名世界五百强公司业务分析师
微软国际认证专家/微软Office金牌讲师
金山国际认证委员会认证专家/商业智能专家

 Microsoft International Certified Professional, focusing on the promotion and secondary development of Office skills
 Served as a business analyst for the world's top 500 companies for a long time
 Nine years of in-house training experience, providing office skills training for hundreds of enterprises;
 Understands the actual needs of the business
 Long term training provider for Microsoft, the American Chamber of Commerce, European Chamber of Commerce, SAIC, China Mobile, Weiquan, Kangshifu and many other well-known enterprises

Related

Contact