课程受益 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
- 适合希望通过EXCEL快速提高工作效率,掌握数据分析方法的企业员工。
- Suitable for employees who want to improve their work efficiency and master data analysis methods.
课程纲要 Training Outline
1. Excel 数据验证 | Data verification
- 数据二级验证 | Secondary data verification
- 限制数据重复录入 | Limit repeated data entry
- 数据动态监控 | Data dynamic monitoring
- 数据表误差比对与突出显示 | Data sheet error comparison and highlighting
- 数据保护之单元格、工作表、工作薄和角色管理 | Role management of data protection: cell, worksheet and workbook
2. 表格灵魂:函数公式魅力 | Soul of Table: The Charming of Formulas
- 公式与基础函数 | Formula and basic function
- 统计求和家族 | Sum, SUMIF, Count, CountIF, CountIFS
- 逻辑查找帮你解难题 | Solve difficult problems - Logic search: Lookup, VLookup, Match
- 日期函数 | Data function: Datedif, networkdays
- 其他高阶实用函数:Sumproduct, Index, Offset函数
3. 表格利器:透视规划分析 | The Weapon of Table: PivotTable
- 初始数据透视表 | Initial PivotTable
- 同一字段不同汇总方式 | Different summary methods for the same syllable
- 透视表自动和手动组合| Automatic and manual combination of pivot table
- 环比和同比 | Month / Year comparison
- 动态数据透视表设置 | Dynamic PivotTable settings
4. 表格印象:图像表演之道 | The Impression of Table: Business charts
- 迷你图、双Y轴图、 复合饼图 | Mini chart, double Y-axis chart, pie chart
- 图表美化:柱形图、折线图、 饼图 | Chart beautification: column chart, line chart, pie chart
- 计划与实际对比图制作:温度计柱形图、柱形+堆积图 | Making contrast: thermometer column chart, column stack chart
5. 动态仪表板制作 | Dynamic Dashboard
- 数据和图表的关联 | Association of data and charts
- 图表与切片器的关联 | Correlation between chart and slicer
- 切片器联动与布局 | Slicer linkage and layout
- 切片器美化 | Slicer beautification
Payment 付款方式:报名后请将会议费汇款至以下账户,并在银行转账单上附注BJ20220621 或 联系商会工作人员微信付费
A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
北京市朝阳区新源南路6号京城大厦
Cancellation 取消政策:
If you cannot attend an event for which you have registered, please cancel your registration no later than 48 hours prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be fully charged for event costs. You may cancel online or notify the contact person in the European Chamber.如果您不能参加已注册过的活动,请至少在活动开始48小时之前取消您的注册。若您未能及时地通知我们,我们将收取您相应的活动费用。您可以联系工作人员取消,也可以网上自行取消。