Home

课程目标：

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


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.    表格根基：高级操作技巧

1.1.  分列与快速填充

1.2.  条件格式

1.3.  标记和删除重复值

1.4.  数据验证

1.5.  数据保护密码设置


2.    表格灵魂：函数公式魅力

2.1.  你必须知道的函数公式基础

2.2.  统计求和函数

2.3.  逻辑查找函数


3.    表格利器：透视规划分析

3.1.  单表和多表创建透视表

3.2.  自动分组和手动分组

3.3.  切片器联动

3.4.  值汇总方式

3.5.  动态数据透视表


4.    Power Query

4.1.  工作簿自动汇总

4.2.  文件夹自动汇总


5.    表格印象：图标演示之道

5.1.  制作美观专业的图表

5.2.  迷你图、双Y轴图、复合饼图等制作

5.3.  图表美化三部曲


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

1.    Table Basis: Advanced Skills

1.1.  Text to columns and flash fill

1.2.  Conditional formatting

1.3.  Mark and delete the duplicates

1.4.  Data validation

1.5.  Data protection


2.    Soul of Table: The Charming of Formulas

2.1.  Formulas basis you need to know

2.2.  Statistical formulas

2.3.  Lookup &reference formulas


3.    The Weapon of Table: Pivot Table

3.1.  Creating PivotTable from single and multiple worksheets

3.2.  Date, number and text grouping

3.3.  Slicer connection

3.4.  Summarized value type

3.5.  Dynamic PivotTable


4.    Power Query

4.1.  Automatic summarizing of workbook

4.2.  Automatic summarizing of file


5.    The Impression of Table: Business charts

5.1.  Making professional and beautiful charts

5.2.  Sparklines, combo charts and pie of pie, etc.

5.3.  3 steps to beautify charts


6.    Q&A

Speakers

  • 晏艳 Grace Yan

    晏艳 Grace Yan

    易迪思金牌讲师
    微软 Office 中英文双语讲师
    微软 Office2013 认证大师 Microsoft Certified Office Master

     多家 500 强企业 Office 培训授课经验
     长期为客户和学员解决 Office 问题
     多个自媒体公众号微课讲师
     受众学员 10000 人以上

    多年 500 强外企工作经验，能准确挖掘企业培训需求，快速帮助学员提高 Office 技能；课程结构条例清晰，课程案例吻合工作需要；授课风格生动有趣，善于调动学员积极性，深受学员喜欢和好评。

    view more

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. 

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

Member Ticket
Member Price RMB 998
Member Company Employee Ticket
Standard Price RMB 998
Non-member Ticket
Standard Price RMB 1,098

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.