课程受益
- 掌握职场高阶函数,处理更为复杂的数据统计与分析;
- 掌握数据分析的相关工具,有效挖掘数据价值;
- 掌握数据看板制作方法,数据分析结果更全面、系统及高效;
- 掌握高阶商务图表类型的绘制,让数据传达形式更为新颖及多样化.
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.
特别提示
建议使用Windows微软office 2013以上版本参与本课程,部分应用Mac版无法实现
We recommend to use windows Microsoft office 2013 in this training. Some applications cannot be realized in Mac version.
课程大纲
1 Excel技巧与操作
1.1 数据二级验证
1.2 限制数据重复录入
1.3 数据动态监控
1.4 数据表误差比对与突出显示
1.5 数据保护之单元格、工作表、工作簿和角色管理
2 Excel函数进阶
2.1 Vlookup的多条件匹配
2.2 Xlookup来了
2.3 Sumproduct函数
2.4 Offset函数
2.5 Index函数
3 数据新招——PowerQuery
3.1 工作簿多工作表动态快速汇总
3.2 多工作簿多工作表动态快速汇总
3.3 追加查询
3.4 合并查询
3.5 分列与格式
3.6 数据分组汇总
4 数据超级透视表——Power Pivot
4.1 日期维度表创建
4.2 星形模型
4.3 雪花模型
4.4 度量值初试
4.5 度量值规则
5 Dashboard动态仪表板制作
5.1 数据和图表的关联
5.2 图表与切片器的关联
5.3 切片器联动与布局
5.4 切片器美化
for bank transfers, please use BJEVENT20220112 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.