Dear members and friends,
The European Union Chamber of Commerce in China, Shenyang Chapter is thrilled to invite you to participate in the Online Training on Advanced EXCEL - Efficient Application of EXCEL 23rd July 09:00-16:30 in Chinese.
中国欧盟商会沈阳分会荣幸地邀请您参与2020年7月23日日09:00-16:30举办的在线培训: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;
课程受益
• 掌握职场高阶函数,处理更为复杂的数据统计与分析;
• 掌握数据分析的相关工具,有效挖掘数据价值;
• 掌握数据看板制作方法,数据分析结果更全面、系统及高效;
• 掌握高阶商务图表类型的绘制,让数据传达形式更为新颖及多样化;
Course Audience
Suitable for employees who want to improve their work efficiency and master data analysis methods.
课程受众
适合希望通过EXCEL快速提高工作效率,掌握数据分析方法的企业员工。
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. Table Management: Data Consolidation
2.1. Group calculation
2.2. Advanced filtering
2.3. Sorting and filtering
3. Soul of Table: The Charming of Formulas
3.1. Formulas basis you need to know
3.2. Formulas evaluating and debugging
3.3. Text formulas
3.4. Statistical formulas
3.5. Lookup &reference formulas
4. AI Excel: Smart Table
4.1. Quickly beautifying table
4.2. Header freezing
4.3. Automatically summing up
4.4. Automatically filling up formulas
5. The Weapon of Table: PivotTable
5.1. Creating PivotTable from single and multiple worksheets
5.2. Date, number and text grouping
5.3. Slicer connection
5.4. Summarized value type
5.5. Dynamic PivotTable
6. Power Query
6.1. Automatic summarizing of workbook
6.2. Automatic summarizing of file
6.3. Data grouping
6.4. Queries merging and appending
7. The Impression of Table:Business charts
7.1. Brief Introduction of charts
7.2. Suggestion on choosing charts
7.3. Making professional and beautiful charts
7.4. Sparklines, combo charts and pie of pie, etc.
7.5. 3 steps to beautify charts
8. Q&A
课程大纲
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. 冻结首行
4.3. 自动汇总
4.4. 公式自动填充
5. 表格利器:透视规划分析
5.1. 单表和多表创建透视表
5.2. 自动分组和手动分组
5.3. 切片器联动
5.4. 值汇总方式
5.5. 动态数据透视表
6. Power Query
6.1. 工作簿自动汇总
6.2. 文件夹自动汇总
6.3. 数据分组
6.4. 合并及追加查询
7. 表格印象:图标演示之道
7.1. 各种图表简介
7.2. 图表类型选择建议
7.3. 制作美观专业的图表
7.4. 迷你图、双Y轴图、复合饼图等制作
7.5. 图表美化三部曲
8. 总结提高:学以致用,整体答疑
Notes:
1. Please register for this activity on the website in advance and be sure to specify the email address. The staff of the Chamber of Commerce will send the meeting link to the registered participants by mail before the meeting starts. Please register before July 20th, 2020.请提前在网站上报名参加本次活动,务必填写邮箱地址,商会工作人员在会议开始前将会议链接通过邮件发送给参会人员。截止时间2020年7月20日。
2. The seminar will be broadcast live through Zoom platform. In order to ensure the smoothness of your participation, it is recommended to download Zoom on your device in advance. 研讨会将通过Zoom平台进行现场直播。 为了保证您参与的流畅性,建议您提前下载Zoom。
3. How to join: you can log on to Zoom website https://www.zoom.com.cn/join, enter the meeting ID and password sent to you by the staff of the Chamber of Commerce, and join the meeting; Or you can download Zoom App on your mobile phone or computer, enter the meeting ID and password in the app, and join the meeting. zoom使用方法:登录Zoom网站https://www.Zoom.com.cn/join,输入商会工作人员发给您的会议ID和密码,加入会议;手机或电脑上下载Zoom App,打开App输入会议ID和密码,加入会议。