The European Union Chamber of Commerce in China Southwest China Chapter is delighted to invite you to attend the online training Excel: Data analysis and presentation in work report on 5th August, Thursday, 2021. Training language: Chinese.
中国欧盟商会西南分会诚邀您参加将于2021年8月5日（星期四）举行的线上培训：工作汇报中的数据分析与呈现。培训语言：中文。
学习目标 Course Objectives:
1. 掌握以数据分析为基础的业务问题解决思路
2. 掌握用Excel追踪、管理、分析和展示数据的实用技巧
3. 最大化工作汇报中的数据价值，用数据增强汇报的逻辑、故事性和说服力
1. Business problem solving based on data analysis
2. Practical skills of tracking, managing, analyzing and displaying data with Excel
3. Maximize the value of data in the work report, and use data to enhance the logic, story telling and persuasion of the report
课程大纲 Course Outline:
单元1：工作汇报中的Excel应用 Work report with Excel
数据分析报告的类型，数据分析报表结构，撰写分析报告的要求
Data analysis reports include structure of data analysis report and requirements for writing analysis report
单元2：数据分析基础 Data Analysis Fundamentals
绝对引用，定义名称，常用函数（SUM, SUMIF, COUNT, COUNTA, COUNTIF, DATE, TODAY, NOW, TRIM, LEFT, RIGHT, ROUND, ROUNDUP, ROUNDDOWN, IF, VLOOKUP…）
单元格属性，使用表样式，使用条件格式
Absolute Reference, Name Define, Frequently Used Functions (SUM, SUMIF, COUNT, COUNTA, COUNTIF, DATE, TODAY, NOW, TRIM, LEFT, RIGHT, ROUND, ROUNDUP, ROUNDDOWN, IF, VLOOKUP …), Cell Format, Table Styles, Conditional Formatting)
单元3：数据库管理Database Management
规范化数据，利用自定义列表控制排序，数据库高级筛，数据库函数 (DSUM, DCOUNT, DAVERAGE…)，
分类汇总，合并计算工作表，数据导入导出
Data Normalization, Use Custom List For Data Sorting, Advanced Filter, Database Functions (DSUM, DCOUNT, DAVERAGE…), Subtotal, Consolidation, Import and Export Data
单元4：数据透视表及图表报告 Pivot Table & Chart Report
整理数据，创建透视表，改变透视结构，透视表汇总，透视表计算，切片器以及时间线，分组功能，
Organize Your Data, Create A Pivottable, Change Layout, Pivottable Summary, Calculated Field, Slicer, Timeline, Grouping Intervals，
图表美化,Make Excel chart fruitful
柱状图，折线图，圆饼图， 树状图， 瀑布图， 漏斗图 ,直方图,箱形图,散点分布图， 填充式图表,等等
Histogram chart, Line chart, Round pie chart, Tree chart, Waterfall figure chart, Funnel figure chart, Histogram chart, Box figure chart, Thermometer chart, Filled chart, etc.
Registration 活动注册
Registration and payment by 11:00am, 4th August 2021. Please provide Company Name, Name, Title (both in Chinese and English), Mobile Number and Email Box.
活动注册和付费截止2021年8月4日上午11点。报名时请务必提供中英文的公司名称、姓名、职务，手机号码和邮箱。
1. Online registration 网上注册
2. Email registration. Email: mhuang@europeanchamber.com.cn . The registration is complete only if a confirmation letter is received. 邮件注册，邮箱 mhuang@europeanchamber.com.cn 。收到商会邮件确认后注册成功。
报名后可将报名费转账至以下账户，并在银行转账单上附注 CD20210805；也可以联系商会工作人员获取商会微信账号，付款后备注附注 CD20210805。
RMB Bank Account 报名汇款账号
A/C Name: 中国欧盟商会
China CITIC Bank 中信银行京城大厦支行
Capital Mansion Sub Branch
No.6, Xinyuan Nan Road
Chaoyang District, 100004 Beijing
A/C No. 银行账号: 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) 网站注册者可在网上取消。
