中国欧盟商会西南分会诚邀您参加将于2020年11月13日(星期五)举行的全天线上培训:Excel的高效应用。培训语言:中文。
The European Union Chamber of Commerce in China Southwest Chapter is delighted to invite you to join the One Day training (online): Efficient Application Tips of Excel on 13th Nov (Friday), 2020. Training Language: Chinese.
课程受益 Course Benefits
-
Master the higher-level functions to process more complex data statistics and analysis;
-
Master the relevant tools of data analysis and find the value of data effectively;
-
Master data table production methods, make data analysis results more comprehensive, systematic and efficient;
-
Master the drawing methods of high-level business chart types to make the forms of data transmission more novel and diversified.
课程受众 Target Audience
适合希望通过EXCEL快速提高工作效率,掌握数据分析方法的企业员工。
Suitable for employees who want to improve their work efficiency and master data analysis methods.
课程大纲
一、表格根基:高级操作技巧
1. 智能表格
2. 条件格式
3. 分列与快速填充
4. 一级和二级数据验证
5. 工作簿、工作表和单元格数据保护
6. 排序与自定义排序
7. 筛选与高级筛选
8. 分类汇总
9. 邮件合并
二、表格灵魂:函数公式魅力
1. 公式与基础函数
2. 统计求和家族: Sum, sumif, sumifs, count, countif, countifs
3. 逻辑查找帮你解难题: lookup, vlookup, index,match
4. 日期函数: datedif, networkdays
三、表格利器:透视规划分析
1. 初始数据透视表
2. 同一字段不同汇总方式
3. 透视表自动和手动组合
4. 切片器使用与联动
5. 动态数据透视表设置
四、表格印象:图表演示之道
1. 迷你图、双Y轴图、复合饼图
2. 图表美化:柱形图、折线图、饼图
3. 计划与实际对比图制作:温度计柱形图、柱形+堆积图
五、总结提高:学以致用,整体答疑
Course Outline
Table Basis: Advanced Skills
1. Smart form
2. Conditional format
3. Sorting and fast filling
4. Primary and secondary data validation
5. Data protection of workbooks, worksheets and cells
6. Sorting and user-defined sorting
7. Screening and advanced screening
8. Summary
9. Mail merge
Soul of Table: The Charming of Formulas
1. Formula and basic function
2. Sum, SUMIF, SUMIF, Count, CountIF, CountIFS
3. Solve difficult problems - Logic search: Lookup, VLookup, Index, Match
4. Date function: datedif, networkdays
The Weapon of Table: PivotTable
1. Initial PivotTable
2. Different summary methods for the same syllable
3. Automatic and manual combination of pivot table
4. Slicer use and linkage
5. Dynamic PivotTable settings
The Impression of Table: Business charts
1. Mini chart, double Y-axis chart, Pie chart
2. Chart beautification: column chart, line chart, pie chart
3. Making contrast: thermometer column chart, column stack chart
问答 Q&A
Remark 注意事项:
Please register and arrange payment by 11th Nov, 2020. 请于2020年11月11日之内报名缴费。
付款方式:报名后可将报名费转账至以下账户,并在银行转账单上附注 CD20201113;也可以联系商会工作人员获取支付宝账号或商会微信账号,付款后备注附注 CD20201113。
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号京城大厦
Registration 活动注册
1. Online registration by 11th Nov, 2020. 网上注册(截止2020年11月11日)。
2. Email registration by 11th Nov, 2020: please send Company Name, Name, Title (both in Chinese and English), Mobile Number and Email Box to mhuang@europeanchamber.com.cn . The registration is complete only if a confirmation letter is received. 邮件注册
(截止2020年11月11日):请将中英文的公司名称、姓名、职务,手机号码和邮箱发送到 mhuang@europeanchamber.com.cn 。收到商会邮件确认后注册成功。
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) 网站注册者可在网上取消。