Home

做完年终汇报，你是否才刚刚从上一年度复杂繁琐的数据中脱身？新年伊始，何不从一开始就设置好各类数据报表中的规则，在需要数据汇总的关键时刻，一键快速解决问题。本课程将为你提供Excel相关的实用秘籍，帮助你在年初做好规划，提升全年数据分析效率。


Have you just got out of the complicated data after making the year-end report? Why not set up the data rules in different kinds of reports at the beginning of the new year? It will help you solve the problem quickly at the critical moment when data summary is needed. This training will provide you with practical tips related to excel to help you organize data and improve the efficiency of data analysis.


课程受益

  • 掌握职场高阶函数，处理更为复杂的数据统计与分析；
  • 掌握数据分析的相关工具，有效挖掘数据价值；
  • 掌握数据看板制作方法，数据分析结果更全面、系统及高效；
  • 掌握高阶商务图表类型的绘制，让数据传达形式更为新颖及多样化；


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;

Session Outline

一、表格根基：高级操作技巧

  1. 智能表格
  2. 条件格式
  3. 分列与快速填充
  4. 工作簿、工作表和单元格数据保护
  5. 邮件合并


二、表格灵魂：函数公式魅力

  1. 公式与基础函数
  2. 统计求和家族: Sum, sumif, sumifs, count, countif, countifs
  3. 逻辑查找帮你解难题: lookup, vlookup，match
  4. 日期函数: datedif, networkdays


三、表格利器：透视规划分析

  1. 初始数据透视表 
  2. 同一字段不同汇总方式 
  3. 透视表自动和手动组合 
  4. 切片器使用与联动
  5. 动态数据透视表设置


四、Power Query

  1. 工作簿自动汇总
  2. 文件夹自动汇总


五、表格印象：图表演示之道

  1. 迷你图、双Y轴图、复合饼图
  2. 图表美化：柱形图、折线图、饼图
  3. 计划与实际对比图制作：温度计柱形图、柱形+堆积图


六、总结提高：学以致用，整体答疑

Table Basis: Advanced Skills

  1. Smart form
  2. Conditional format
  3. Sorting and fast filling
  4. Data protection of workbooks, worksheets and cells
  5. Mail merge


Soul of Table: The Charming of Formulas

  1. Formula and basic function
  2. Sum, SUMIF, SUMIF, Count, CountIF, CountIFS
  3. Solve difficult problems - Logic search: Lookup, VLookup, Match
  4. Date function: datedif, networkdays


The Weapon of Table: PivotTable

  1. Initial PivotTable
  2. Different summary methods for the same syllable
  3. Automatic and manual combination of pivot table
  4. Slicer use and linkage
  5. Dynamic PivotTable settings


Power Query

  1. Automatic summarizing of workbook
  2. Automatic summarizing of file


The Impression of Table: Business charts

  1. Mini chart, double Y-axis chart, Pie chart
  2. Chart beautification: column chart, line chart, pie chart
  3. Making contrast: thermometer column chart, column stack chart


Q&A

Agenda


上课时间 ：01月07日 9:00-16:30

Time: January 7  9:00-16:30

Speakers

  • 晏艳

    晏艳

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

    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

    view more

Who Should Attend?

适合希望通过EXCEL快速提高工作效率，掌握数据分析方法的企业员工。


Suitable for employees who want to improve their work efficiency and master data analysis methods.

Tickets

Please use your own name and email when registering for a training session. Additional fees may apply if you fail to register under your own identity. 


A prepayment is required for all full-day training sessions. 

全天培训课程需要提前付款。


Half-day session training vouchers cannot be used for full-day training programs.

全天会员培训无法使用"半天会员培训免费"券。

Standard Ticket
Standard Price RMB 998

Registration

  • All registrations shall be made online before the session. Payment also shall be made before the session.
  • AmCham Shanghai members are eligible to attend at "Member Rate"; Employees who work at AmCham Shanghai member companies are eligible to attend at "Employee Rate"; Non-members are eligible to attend at "Non-Member Rate".
Cancellation Policy
  • Cancellation: If you need to cancel your registration, please notify David Ma at (86 21) 6169 3016 or email david.ma@amcham-shanghai.org at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.