Save the date
Save the dateMarch 2, 20239:00 AM - 4:30 PM (GMT+8) Add to Calendar
Venue Location
Venue Location

Online

Shanghai, China

Show on map
Organizer
Organizer
Organizer:
Contact Person: Ray Cheng
Home
Home

课程受益


● 掌握Excel使用技巧,改善工作方式,提高工作效率;

● 设计令人赏心悦目的专业数据报表,通过三个以上的函数嵌套解决复杂工作问题;

● 创建"会说话"的专业图表,通过数据透视表随便所欲生成各种报表。


Course Benefits



● Let the trainees master excel skills, and improve the way of working and increase work efficiency;

● Help trainees design pleasing professional data reports and solve complex work problems through nesting of more than three functions;

● Create vivid and talkative professional charts and generate any kind of reports you want from pivot tables.


Session Outline
Session Outline

课程大纲

 

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

- 分列与快速填充

- 条件格式

- 标记和删除重复值

- 数据一级和二级验证

- 单元格、工作簿和工作簿保护

- 排序和高级筛选


二、表格灵魂:常用函数解析

- 公式与基础函数

- 统计求和家族: Sum/Sumif Sumifs/Count/Countif/Countifs

- 逻辑查找帮你解难题: If/Vlookup/Match/Index/ Indirect等


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

- 单表和多表创建透视表

- 自动分组和手动分组

- 切片器联动

- 值汇总方式

- 动态数据透视表

 

四、表格印象:图表演示之道 

- 各种图表简介

- 图表类型选择建议

- 制作美观专业的图表

- 创意折线图、柱形图和比例图


五、总结提高:学以致用,整体答疑  

Outline

 

1. Form foundations: Advanced manipulation skills

- Columnar and Flash Fill

- Conditional Formatting

- Mark and remove duplicate values

- Data primary and secondary validation

- Cell, Workbook and Workbook protection

- Sorting and Advanced filtering


2. Form Soul: Analysis of Common Functions 

- Formulas and Basic functions

- Statistical Sum family: Sum / Sumif/Sumifs / Count / Countif / Countifs

- Logical search to help you solve puzzles: If/Vlookup/Match/Index /Indirect etc.


3. Table tool: Perspective planning analysis

- Create pivot tables with single and multiple tables

- Automatic grouping and manual grouping

- Slicer linkage

- Value aggregation method

- Dynamic pivot table


4. Impressions of Tables: The Way of Graph Presentation

- Introduction to various charts

- Chart type selection suggestion

- Create beautiful and professional charts

- Creative line, column and ratio charts


Q&A

Speakers
Speakers
  • 晏艳 Grace Yan

    晏艳 Grace Yan

Who Should Attend?
Who Should Attend?

课程受众


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


Course Audience



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

Tickets
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 1,098

Member Company Employee Ticket

RMB 1,098

Non-member Ticket

RMB 1,298
Registration
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 Ray Cheng at (86 21) 6169 3015 or email ray.cheng@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.
Sponsors and Partners
Sponsors and Partners