The European Union Chamber of Commerce in China, Shenyang Chapter, is thrilled to invite you to the online training: Advanced Excel, 9:00—16:30, 15th September.
中国欧盟商会沈阳分会荣幸的邀请您参与于9月15日 9:00—16:30举办的在线培训:EXCEL进阶培训--EXCEL高效应用。
EXCEL进阶培训--EXCEL高效应用
课程受益
• 掌握职场高阶函数,处理更为复杂的数据统计与分析;
• 掌握数据分析的相关工具,有效挖掘数据价值;
• 掌握数据看板制作方法,数据分析结果更全面、系统及高效;
• 掌握高阶商务图表类型的绘制,让数据传达形式更为新颖及多样化;
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;
课程受众
适合希望通过EXCEL快速提高工作效率,掌握数据分析方法的企业员工。
Course Audience
Suitable for employees who want to improve their work efficiency and master data analysis methods.
时间
9月15日 9:00—16:30
Time
9:00—16:30 15th September
课程大纲
1. 表格根基:高级操作技巧
1.1. 分列与快速填充
1.2. 条件格式
1.3. 标记和删除重复值
1.4. 数据验证
1.5. 数据保护密码设置
2. 表格灵魂:函数公式魅力
2.1. 你必须知道的函数公式基础
2.2. 统计求和函数
2.3. 逻辑查找函数
3. 表格利器:透视规划分析
3.1. 单表和多表创建透视表
3.2. 自动分组和手动分组
3.3. 切片器联动
3.4. 值汇总方式
3.5. 动态数据透视表
4. 功率查询
4.1. 工作簿自动汇总
4.2. 文件夹自动汇总
5. 表格印象:图标演示之道
5.1. 制作美观专业的图表
5.2. 迷你图、双Y轴图、复合饼图等制作
5.3. 图表美化三部曲
6. 总结提高:学以致用,整体答疑
Outline
1. Table Basis: Advanced Skills
1.1. Text to columns and flash fill
1.2. Conditional formatting
1.3. Mark and delete the duplicates
1.4. Data validation
1.5. Data protection
2. Soul of Table: The Charming of Formulas
2.1. Formulas basis you need to know
2.2. Statistical formulas
2.3. Lookup &reference formulas
3. The Weapon of Table: PivotTable
3.1. Creating PivotTable from single and multiple worksheets
3.2. Date, number and text grouping
3.3. Slicer connection
3.4. Summarized value type
3.5. Dynamic PivotTable
4. Power Query
4.1. Automatic summarizing of workbook
4.2. Automatic summarizing of file
5. The Impression of Table:Business charts
5.1. Making professional and beautiful charts
5.2. Sparklines, combo charts and pie of pie, etc.
5.3. 3 steps to beautify charts
6. Q&A
Registration:
1. Online registration
2. Email registration: please send Company Name, Name, Title, Mobile Number to shenyang@europeanchamber.com.cn. The registration is complete only if a confirmation letter is received.
3. This is a workshop broadcast on Zoom platform. Please confirm that your email address is correct when registering on our website or through email to chongqing@europeanchamber.com.cn; The meeting link and ID will be sent to your registration email. For more information on how to use Zoom, please visit: https://zoom.com.cn/. You are recommended to download the Zoom on your device on advance.
4. Please register before 10th September.
活动注册:
1. 网上注册
2. 邮件注册:请将公司名称,姓名,职务,手机号码发送到 shenyang@europeanchamber.com.cn。收到商会邮件确认后注册成功。
3. 本次研讨会将通过线下研讨与线上Zoom平台同步举行。请您在通过官网或向 chongqing@europeanchamber.com.cn 发送邮件报名时,确认邮箱地址填写正确。本次讲座的链接和ID将通过邮件发送给您的报名邮箱。关于如何使用Zoom平台的更多信息,请您访问:https://zoom.com.cn/。建议您提前在您的设备上下载Zoom软件。
4. 请于2020年9月10日前报名。
RMB Bank Account 报名汇款账号:
A/C Name: 中国欧盟商会
China CITIC Bank 中信银行京城大厦支行
A/CNo.: 7110210182500027543
北京市朝阳区新源南路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 shenyang@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.
取消条款:
如果您不能参加已注册过的活动,请在不少于一个工作日的时间内取消您的注册。若您未能及时地通知我们,我们将收取您相应的活动费用。
如取消注册您可以:1) 发送邮件至shenyang@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 Marine Chen at shenyang@europeanchamber.com.cn
顾问委员会政策:
欧盟商会顾问委员会成员将获得包括讲座、会议、工厂参观等商会活动的免费入场券。每次活动仅限两人免费参加,额外参与者按会员价格收取门票。
欧盟商会顾问委员会成员在参加商会培训和其他特殊活动时需按普通会员价格收取门票,例如:欢迎酒会、政府答谢晚宴、或社交活动等。
获取更多相关信息请联系杨琛shenyang@europeanchamber.com.cn