[Online Training] Excel Skills | Excel秘籍

This training is conducted in Chinese. 本次课程用中文授课。

课程受益 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

课程受众 Who should attend

适合希望通过EXCEL快速提高工作效率，掌握数据分析方法的企业员工。
Suitable for employees who want to improve their work efficiency and master data analysis methods.

课程纲要 Training Outline

1. 表格根基：高级操作技巧 | Table Basis 

• 智能表格 | Smart form
• 条件格式 | Conditional format
• 分列与快速填充 | Sorting and fast filling
• 工作簿、工作表和单元格数据保护 | Data protection of workbooks, worksheets and cells
• 邮件合并 | Mail merge


•  

2. 表格灵魂：函数公式魅力 | Soul of Table: The Charming of Formulas

• 公式与基础函数 | Formula and basic function
• 统计求和家族: Sum, sumif, sumifs, count, countif, countifs | Sum, SUMIF, SUMIF, Count, CountIF, CountIFS
• 逻辑查找帮你解难题: lookup, vlookup，match | Solve difficult problems - Logic search: Lookup, VLookup, Match
• 日期函数： datedif, networkdays | Date function: datedif, networkdays


•  

3. 表格利器：透视规划分析 | The Weapon of Table: PivotTable

• 初始数据透视表 | Initial PivotTable
• 同一字段不同汇总方式 | Different summary methods for the same syllable
• 透视表自动和手动组合 | Automatic and manual combination of pivot table
• 切片器使用与联动 | Slicer use and linkage
• 动态数据透视表设置 | Dynamic PivotTable settings


•  

4. Power Query

• 工作簿自动汇总 | Automatic summarizing of workbook
• 文件夹自动汇总 | Automatic summarizing of file


•  

5. 表格印象：图表演示之道 | 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


•  

6. 总结提高：学以致用，整体答疑 | Q&A

Trainer 讲师

 

 

 

 

 

 

Grace YAN 晏艳

Microsoft Office International Certified Master
Trainer working experience for the top 10 foreign companies 
Working experience of the world's top 500 companies
Training experience of the world's top 500 companies
Bilingual lecturer
More than 10000 in-house trainees

微软Office国际认证大师
曾任全球前10强外企培训师
知名世界500强外企从业经历
多家世界500强企业Office授课经验
中英双语讲师
线下受众学员10000人以上

 

Registration 课程报名

Please scan the below QR code or send email to sc-hr(@)ccifc.org

The connecting processes will be sent by email after registration | 报名成功后会发送网课登录信息到邮箱。