The European Chamber Southwest China Chapter is delighted to invite you to join the full day training: Excel Application Skills for Business Work on 10th April, 2019 (Thursday) in Chengdu.

中国欧盟商会西南分会诚邀您于4月10日（星期三）参加商务办公Excel实用技能全天中文培训成都场。

Language 语言：Chinese 中文

Trainees need to bring their own laptops. Software version required：Office 2013 学员需自带笔记本电脑，软件版本为Office 2013。

课程简介

在现代企业中涉及数据管理、分析的需求日趋增强， EXCEL作为办公自动化软件OFFICE 中的重要成员，凭借其强大的数据处理功能，在人们日常工作中的应用也越来越广泛和深入。本课程模拟人们的工作场景，采用大量的实际案例，对职场人士在应用EXCEL进行数据处理中所面临的问题、常见的使用需求，以及对EXCEL相关应用的短板和盲区进行有针对性的讲解和训练，促使学员全方位地了解及掌握EXCEL的功能及应用技巧，更大地满足日常工作中多样化的数据处理需求，并能极大提升办公效率和数据处理的质量。

培训目标

•  掌握表格安全性控制方法
•  了解EXCEL表格的可视性美化方法
•  熟练掌握EXCEL数据统计分析工具
•  掌握多种常用数据图表的制作
•  熟练掌握常用函数的应用，掌握函数嵌套使用的方法，了解数组函数的应用
•  了解EXCEL开发工具的应用
•  了解宏的录制及基础的VBA编写

培训内容

1.   数据汇总及数据源表的保护

      1.1 多表合并计算

      1.2 利用有效性控制表格内容输入

      1.3   工作表和单元格的保护

      1.4 隐藏公式和函数

      1.5 表格按区域分设权限

2.   数据展现--字不如表，表不如“图”

      2.1 在图表上显示最大值、最小值和平均线

      2.2 函数与开发工具动态图表

3.   用透视表轻松搞定多业务条件动态分析

      3.1 通过透视表快速对数据进行汇总、计数、分类等

      3.2 透视表中的数据进行分组

      3.3 将透视表统计结果进行百分比显示

      3.4 将透视表统计结果进行筛选和排序

      3.5 多纬度筛选透视结果实现统计数据动态显示

      3.6 透视图的应用

      3.7 透视表转为数据表样式

      3.8 对透视表进行合并单元格

      3.9 拆分透视表

4.   EXCEL中不可不学的函数

      4.1 MIN\MAX

      4.2 IF

      4.3 SUMPRODUCT

      4.4 VLOOKUP\CHOOSE

      4.5 DSUM\DCOUNT

      4.6 OFFSET

      4.7 GETPIVOTDATA

5.   高效快捷的宏应用

      5.1 用宏一键快速提取信息拆分表格

      5.2 编写VBA批量新建工作表并更名

Agenda 课程安排

09:00 - 09:25 Registration 签到

09:25 - 09:30 Opening by EUCCC 欧盟商会开场词

09:30 - 11:00 Morning Training Session 上午培训

11:00 - 11:10 Tea Break 茶歇

11:10 - 12:35 Morning Training Session 上午培训

12:35 - 14:00 Lunch and Tea Break 午餐及茶歇

14:00 - 15:30 Afternoon Training Session 下午培训

15:30 - 15:40 Tea Break 茶歇

15:40 - 17:00 Afternoon Training Session 下午培训

Registration 活动注册

1. Online registration
2. Email registration: please send Company Name, Name, Title, Mobile Number to mhuang@europeanchamber.com.cn. The registration is complete only if a confirmation letter is received.

1. 网上注册
2. 邮件注册:请将公司名称，姓名，职务，手机号码发送到mhuang@europeanchamber.com.cn。收到商会邮件确认后注册成功。

RMB Bank Account 报名汇款账号

A/C Name: 中国欧盟商会
China CITIC Bank 中信银行京城大厦支行
Capital Mansion Sub Branch
No.6, Xinyuan Nan Road
Chaoyang District, 100004 Beijing
A/CNo. 银行账号: 7110210182500027543
S.W.I.F.T. Code: CIBKCNBJ100
开户行行号: 302100011026
北京市朝阳区新源南路6号京城大厦

Terms & Conditions 活动条款

Events have limited seating so to ensure your attendance we encourage advance online registration and payment for ALL events.

We cannot guarantee entry to anyone not registered in advance.

All our events are held in English and are off-the-record unless otherwise stated.

活动的席位有限。为了确保您的出席，我们建议所有活动都提前网上注册或邮件注册。对于任何未提前注册者，我们都不能保证您的参与。
除特殊说明外,我们全部活动都由英文召开，且均为非公开。

Cancellation Policy 取消报名

If you cannot attend an event 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 mhuang@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.

如果您不能参加已注册过的活动，请在不少于一个工作日的时间内取消您的注册。若您未能及时地通知我们，我们将收取您相应的活动费用。
如取消注册您可以： 1) 发送邮件至mhuang@europeanchamber.com.cn； 或 2) 网站注册者可在网上取消。

Advisory Council Policy 顾问委员会政策

Members of the Advisory Council may receive complimentary admission to Chamber seminars, conferences and factory visits up to two attendees per event. Additional participants will be charged at the member rate.

Advisory Council members will still be charged the standard member rate for participation in training courses and special events, such as gala balls, government appreciation dinners, or admission to corporate social events/tournaments.

For further information contact May Huang via mhuang@europeanchamber.com.cn

欧盟商会顾问委员会成员将获得包括讲座、会议、工厂参观等商会活动的免费入场券。每次活动仅限两人免费参加，额外参与者按会员价格收取门票。

欧盟商会顾问委员会成员在参加商会培训和其他特殊活动时需按普通会员价格收取门票，例如：欢迎酒会、政府答谢晚宴、或社交活动等。

获取更多相关信息请联系黄梅mhuang@europeanchamber.com.cn

Speakers

Ms. Wenwen Wang

易迪思金牌讲师

Ms. Wenwen Wang

易迪思金牌讲师

View speaker details

• 微软MOS大师级认证讲师
• 微软资深办公软件专家
• 国家二级人力资源师
• 从事企业级Office培训咨询及授课工作超过5年
• 服务对象涉及诸多外资合资企业、政府部门
• 具有丰富的企业级Office系列高效办公课程培训经验
• Microsoft Office Specialist Master Instructor
• Senior Microsoft Office Software Expert
• Professional in Human Resources
• More than 5 years of engaging in Office training,
• consultation and lecture in enterprises
• Target customers include foreign-funded enterprises, joint venture enterprises and government departments
• With much experience in Office training courses

授课深入浅出，条理清晰，生动风趣，逻辑性强，沟通表达能 力强。将大量的实际案例经验运用于课堂授课，理论与实践相 结合，让学员更条理、更系统的进行学习。能根据学员的实际情况迅速调整授课方案，解答问题耐心细致，让每次课程的学 员都能收获颇丰，受到学员一致好评。

With strong communication skills, I am good at explaining profound theories of the course in simple language clearly, logically and vividly. Also, a large number of practical cases were used in lectures to promote the combination of the theory and the practice, so that students are able to learn more systematically. Students

benefit a lot from my course, because they can have customized lectures based on their own actual conditions and patient and detailed answers.
Therefore, I receive praise and applause from my students.

Office 办公系统系列课程包含Office System 各组件应用方 式及技巧，主要系列课程如下：
1. Excel 数据分析工具大揭秘
2. Excel 常用函数解析与实战
3. Excel 分析结果的图表化呈现
4. Excel 数据分析思路与规范系列课程
5. Excel 在人事、行政、销售等具体工作的应用案例与分析
6. Excel 和PowerPoint及其Office组件完美协作系列课程
7. PowerPoint 商务演示制作规范与技巧系列课程
8. Word 办公软件应用技巧系列课程
9. Outlook 高效邮件处理及日程管理系列课程

Serial courses of Office System include the application mode and application technique of each component of the Office System. The main serial courses are as following:
1. Excel data analysis tool explanation
2. Excel common functions analysis and practice
3. Excel analysis picture
4. Excel data analysis methods and standards serial courses
5. Excel application cases and analysis in human resources management, administration, marketing and other specific work
6. Perfect cooperation between Excel, PowerPoint and other Office components serial courses
7. PowerPoint business presentations making standards and skills serial courses
8. Word application skills serial courses
9. Outlook efficient mail-handling and schedule management serial courses

Office 办公软件系统系列课程主要服务客户如下：
1. 中国通信服务公司
2. 中南集团
3. 广东电信
4. 深圳国家高技术产业创新中心
5. 罗姆半导体
6. 汇顶科技
7. 和记电讯
8. 深圳信息技术学院
9. 蒙牛乳业
10. 日产通商

Main target customers of serial courses of Office System are as follows:
1. China's communication service Co., LTD
2. Zhongnan Group
3. China Telecom, Guangdong
4. State High-Tech Industrial Innovation Center, Shenzhen
5. ROHM Semiconductor
6. Goodix
7. Hutchison Telecommunications Hong Kong Holdings Ltd
8. Shenzhen Institute & Information Technology
9. China Mengniu Dairy Company Limited
10. Nissan Trading Co. LTD

Location

Related

Contact