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. 智能表格
  • 2. 条件格式
  • 3. 分列与快速填充
  • 4. 一级和二级数据验证
  • 5. 工作簿、工作表和单元格数据保护
  • 6. 排序与自定义排序
  • 7. 筛选与高级筛选
  • 8. 分类汇总
  • 9. 邮件合并

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

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

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

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

4.    表格印象：图表演示之道

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

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

Outline


1.    Table Basis: Advanced Skills

  • 1. Smart form
  • 2. Conditional format
  • 3. Sorting and fast filling
  • 4. Primary and secondary data validation
  • 5. Data protection of workbooks, worksheets and cells
  • 6. Sorting and user-defined sorting
  • 7. Screening and advanced screening
  • 8. Summary
  • 9. Mail merge

2.    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, Index, Match
  • 4. Date function: datedif, networkdays

3.    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

4.    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

5.    Q&A

Speakers

  • Grace Yan晏艳

    Grace Yan晏艳

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

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


Office 办公系统课程

  • 《Excel 商务数据处理与分析》
  • 《Excel 数据透视表与图表美颜》
  • 《Excel 高级商务图表制作》
  • 《Excel 在 HR 中的高效应用》
  • 《大数据时代——用 PPT 讲话》
  • 《Office365 该这样玩儿》

曾经服务客户

雪佛龙中国能源公司

中国石油西南天然气研究院沃尔沃汽车制造有限公司 西南美商会

新电科技有限公司澳新银行

保利地产

当纳利印刷有限公司四川机场集团

中国核动力研究设计院电子科大成都研究院 西安印钞有限公司

中粮大悦城

上海国际医学园区中国中铁西南院

  • Rich office training in many global 500 companies
  • Solove office problem for clients and trainees
  • Micro-class trainer for many Wechat Office Accounts
  • More than 10,000 trainees

Having many working experiences in G500 companies, being able to meet corporate's training requirements, can help students' office skills quickly, the training is designed in good logic, having a humor teaching style in class and being well acclaimed by trainees


Office Series Courses

  • Business Data Processing and Analysis by Excel
  • Excel PivotTable and Charts Beautify
  • How to Make Business Charts by Excel
  • Excel Makes HR Work More Efficient
  • PPT Talks in Age of Big Data
  • Office 365 Is More Than Office

Clients


Chevron China Energy Company

Petrol China

Volvo Cars Co., Ltd

Southwest AmCham

NCSI

ANZ Bank

Poly Real Estate

RR Donnelley Publishing and Printing Company

Sichuan Airport Group

Nuclear Power Institute of China

Chengdu Institute of UESTC

Xi'an Banknote Printing Co., Ltd

Joy City of COFCO

Shanghai International Medical Zone

Southwest Institute of CRECG

Who Should Attend?

课程受众

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

Course Audience

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.
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.