课程受益
• 掌握职场高阶函数,处理更为复杂的数据统计与分析;
• 掌握数据分析的相关工具,有效挖掘数据价值;
• 掌握数据看板制作方法,数据分析结果更全面、系统及高效;
• 掌握高阶商务图表类型的绘制,让数据传达形式更为新颖及多样化.
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版无法实现
Notice
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 数据保护之单元格、工作表、工作簿和角色管理
1 Excel skills and operation
1.1 Secondary data verification
1.2 Limit repeated data entry
1.3 Data dynamic monitoring
1.4 Data sheet error comparison and highlighting
1.5 Role management of data protection: cell, worksheet and workbook
2 Excel函数进阶
2.1 Vlookup的多条件匹配
2.2 Xlookup来了
2.3 Sumproduct函数
2.4 Offset函数
2.5 Index函数
2 Advanced formulas and functions
2.1 Multi-condition matching of vlookup
2.2 Xlookup
2.3 Sumproduct function
2.4 Offset function
2.5 Index function
3 数据新招——PowerQuery
3.1 工作簿多工作表动态快速汇总
3.2 多工作簿多工作表动态快速汇总
3.3 追加查询
3.4 合并查询
3.5 分列与格式
3.6 数据分组汇总
3. New data technology - PowerQuery
3.1 Dynamic summary of multi worksheet
3.2 Dynamic summary of multiple workbooks
3.3 Add query
3.4 Consolidated query
3.5 Breakdown and format
3.6 Data grouping summary
4 数据超级透视表——Power Pivot
4.1 日期维度表创建
4.2 星形模型
4.3 雪花模型
4.4 度量值初试
4.5 度量值规则
4. Super PivotTable report - power pivot
4.1 Creation of date dimension table
4.2 Star model
4.3 Snowflake model
4.4 Preliminary test of measurement value
4.5 Measure rules
5 Dashboard动态仪表板制作
5.1 数据和图表的关联
5.2 图表与切片器的关联
5.3 切片器联动与布局
5.4 切片器美化
5 Dashboard dynamic dashboard
5.1 Association of data and charts
5.2 Correlation between chart and slicer
5.3 Slicer linkage and layout
5.4 Slicer beautification
Terms & Conditions:
This event has limited seating and requires registration and payment in advance. No walk-ins accepted.
Cancellation Policy:
If you cannot attend this training, please cancel your registration at least 3-working days before. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.
To cancel, please contact Ms. Yang Zhao yangzhao@europeanchamber.com.cn
Disclaimer免责声明:
Participants must maintain proper social distancing norms and abide by the Nanjing Municipal Government ’s Epidemic Prevention and Control Rules. If you do not follow the relevant regulations, the European Union Chamber of Commerce in China accepts no responsibility for any of your physical discomfort caused during and after the event. Thank you for your cooperation.
参与活动时,参会人应与他人保持适当距离(防疫考虑)并遵守南京市政府颁布的疫情预防控制要求(例如佩戴口罩等)。如您违反要求,中国欧盟商会对于您在活动中或者活动后的身体不适,不承担任何责任。 感谢您的理解和配合。