课程受益
- 掌握职场高阶函数,处理更为复杂的数据统计与分析;
- 掌握数据分析的相关工具,有效挖掘数据价值;
- 掌握数据看板制作方法,数据分析结果更全面、系统及高效;
- 掌握高阶商务图表类型的绘制,让数据传达形式更为新颖及多样化;
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.
课程大纲
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. Power Query
4.1. 工作簿自动汇总
4.2. 文件夹自动汇总
5. 表格印象:图标演示之道
5.1. 制作美观专业的图表
5.2. 迷你图、双Y轴图、复合饼图等制作
5.3. 图表美化三部曲
6. 总结提高:学以致用,整体答疑
for bank transfers, please use BJEVENT1123 as subject.
bank information:
A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
北京市朝阳区新源南路6号京城大厦
Cancellation Policy
If you cannot attend the training 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 kwang@europeanchamber.com.cn or 2) cancel online if you registered for the event through the website.