中国西南美国商会（重庆）诚挚邀请您参加将于2018年3月7日星期三在德事商务中心举行的Excel商务数据处理培训讲座。
The American Chamber of Commerce in Southwest China (CQ) sincerely invites you to participate in the Excel Business Data Processing Training Seminar on Wednesday, March 7, 2018 at The Executive Centre Chongqing Office.
每逢季度年度工作汇报，您是否都因为制作工作报告而烦恼？ 面对大量的数据，怎么能最快速的整理出需要的报表？ 纷繁的信息和数据怎么才能呈现出最直观的效果？ 无休止的加班何时才能结束？
……
快来体验一下玩转工作报告于掌中的感觉，让我们的课程带您来感受 1 分钟制作出数据报告的急速体验，带您来尝试构建可自动更新报表的过程，带您来改变自己繁忙的工作状态！
Are you mad at making work report at the end of each month or year? How can we rapidly making our report within large amount of data? How to present such diverse information and data in the most intuitive way? And who can end the endless working overtime?
......
Come and join our seminar, you will find making report can be so easy that you have never thought. Experience the rapid pleasure of completing the data report in 1 minute. Try the processes of building automatically updated reports and make your work easier than ever before!
讲座主要内容
Seminar Main Content
Excel 数据透视构建报表
使用数据透视图制作具有专业效果的图表报告
设置让 Excel 复制到 PPT 的数据可以随时更新
软件版本为 Office 2010 或 2013
How to build an Excel pivot table
Make professional report and chart by pivot chart
Let the pivot table refresh at any time
Software version required：Office 2010 or 2013
讲座目标
Seminar Objective
1. 熟练掌握利用数据透视进行数据分析和报表制作的方法和技巧。
2. 了解工作中常见的业绩增长分析、利润分析、任务完成图等汇报表格、图表的构建方法。
3. 学习让从 Excel 到 PPT 数据自动更新的设计流程和注意事项。
1. Master the skill of Excel Pivot table and pivot chart.
2. Understanding how to make the growth analysis, profit analysis, mission completion analysis report by Excel.
3. Learning how to make auto updating report by Excel and PowerPoint.
讲座大纲
Seminar Agenda
1 磨刀不误砍柴工——数据的预处理技巧
1.1 工作报告制作现状
1.2 如何设计构建合理的数据报告
1.3 数据格式的规范化
1 Prepare a reasonable data
1.1 The problem about our data report
1.2 How to design a professional report
1.3 Standard data format
2 快刀斩乱麻——使用数据透视实现 1 分钟报表制作
2.1 数据透视的重要前提
2.2 数据透视的构建
2.3 数据透视的使用技巧
2 Make data report in 1 min by pivot table
2.1 The important prerequisite for pivot table
2.2 Build up a pivot table
2.3 Tips in using pivot table
3 图表之道——视觉力量的体现
3.1 同比增长表的制作
3.2 任务完成图的设计和制作
3 Using Pivot chart to design professional report
3.1 How to make a profit rose report
3.2 How to make an mission completion report
4 强强联手——构建从 Excel 到 PPT 的自动数据流程
4.1 移植数据到 PPT 的技巧
4.2 流程自动化——数据的自动更新
4 Let the report automatic update
4.1 Tips of copy data to PowerPoint
4.2 Set up the updating of report
讲座安排 Seminar Arrangement
演讲嘉宾 Speaker
王文雯 Wenwen WANG
Microsoft Office Specialist Master Instructor, Eddic
🔹微软 MOS 大师级认证讲师
🔹微软资深办公软件专家
🔹国家二级人力资源师
🔹从事企业级 Office 培训咨询及授课工作超过 5 年
🔹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 Audience
在工作中经常需要利用 Excel 统计数据报告，希望深入学习数据透视表和图表报告制作的Excel 用户（中高级水平培训）
For those who often make data report in daily work and want to study pivot table and pivot chart in depth. (Mid-Senior level course)
讲座详情 General Information
日期：2018年3月7日 星期三
Date: Wednesday, March 7th, 2018
时间：下午14:00-17:00
(13:30开始签到)
Time: 14:00-17:00 PM
(Registration will start at 13:30PM)
讲座语言：中文
Language: Chinese
免费参加，请提前预定
FREE ENTRY. Please book in advance.
地址：重庆市渝中区华盛路10号企业天地8号楼25层德事商务中心
Venue: The Executive Centre, 25F, 8 Corporate Avenue, 10 Huasheng Road, Yuzhong District, Chongqing
提示：请自备电脑
Note: Please bring your own laptop
席
位
有
限
席位有限，敬请赐复
Seats are limited. Please R.S.V.P.
报名方式 How to Register
请长按并识别左方二维码填写报名表报名
Please long press and extract the QR code beside to register for this event
或请点击本文末左下方“阅读原文”填写报名表报名
Or press the “Read More” button at the bottom of this page to register
For more info. Please contact Joy.
详情请咨询
Joy: +86 23 6776 7739
点击下方“阅读原文”进行报名
Click HERE to sign up
