Home

In this training session you will learn about:
Reasonable design of Excel data structure
Data collection and analysis skills（Containing PivotTable and other popular functions）
Effective presentation data with chart
The method of data security and protection

主要内容
合理的 Excel 数据结构设计
数据的整理和分析技巧（含数据透视和常用函数）
利用图表有效呈现数据
数据的安全和保护方法软件版本为 Office 2010 或 2007

Course Objectives
1. Master the proposed data source formats in data processing，and correcting errors when establishing data form.
2. Learn and master enhancing the efficiency of processing data, and operation skills.
3. Master the tools of fast-making reports and popular data-analysis functions, and improve the efficiency of data analysis.
4. Pinpoint suitable data presentations and performance practices, highlight the information of data, and improve work report quality

课程目标
1. 掌握数据分析中的理想数据源格式，改变建立数据表格的错误习惯。
2. 学习并掌握能提升数据处理效率的实用功能并掌握操作技巧。
3. 掌握快速进行报表制作的重要工具和常用数据分析函数，提高数据统计分析效率。
4. 找到适合自己的数据呈现方式和表现手法，突出数据信息，提高工作报表质量。

Session Outline

1 Basic data processing flow
  • Data processing workflow
  • Prerequisites of data processing

2 Data collection and sorting
  • Data collection
  • Data sorting
  • Popular tools of data processing
  • Advanced usage of filter
 
3 Faster data analysis
  • Fast data summary
  • Use the Pivot Table to build reports

4 Statistical analysis and report making with function
  • The necessary knowledge of using function
  • The learning of popular function
  • Use the different functions together to solve practical problems——case study
  • Troubleshooting for function error
 
5 The present of data information
  • Professional business chart
  • Use conditional formatting presenting data information

6 Excel reports preparation
  • The Excel report typesetting skills
  • The publish settings of electronic version

1 数据处理基本流程和注意事项
  • 工作中的数据处理流程
  • 数据处理的必要前提
  
2 数据的收集和整理
  • 数据的收集
  • 数据的整理
  • 常用数据处理工具

3 数据的快速统计与分析
  • 利用分类汇总快速统计数据
  • 灵活运用数据透视表构建报表

4 利用函数进行统计分析和报表制作
  • 函数运用的必要准备知识
  • 常用函数的学习
  • 利用函数综合解决实际问题——案例学习
  • 函数常见错误的排除

5 数据信息的呈现
  • 专业化的商务图表应用
  • 使用条件格式呈现数据信息

6 Excel 报表的发布准备
  • Excel 报表排版技巧
  • 电子版本的发布设置
Who should attend?
For people who need to improve their Excel skills, as well as improve their efficiency of data processing（Mid-Senior level course）

本课程适合有需要系统提升 Excel 使用水平，提高数据处理效率的 Excel 用户（中高级水平 培训）

Speakers

  • Pasta Pei (Professional Trainer at Microsoft)

    Pasta Pei

    Professional Trainer at Microsoft

    Pasta Pei has more than 6 years of training experience on corporate IT techniques training and highly efficient Office series course training. He understands the subtleties of customers’ needs, and tailors to their requirements on IT system software applications and training solutions to help improve their work efficiency.

    Pei has intensively researched topics on corporate training and adult education which he uses in his training courses.

    Pei teaches in a simple but profound way; his course structures are logical and coherent. He motivates his attendees with a humourous teaching style that has been well-received in the past.

    view more

Agenda

08:45 Registration & Networking
09:00 Morning Session
10:30 Morning Session Coffee Break
10:45 Morning Session
12:00 Lunch
13:00 Afternoon Session
15:30 Afternoon Session Coffee Break
15:45 Afternoon Session
17:00 Session Ends

Tickets

A prepayment is required when choosing 'Members only price' or 'Standard Price'.

“会员票价”及“标准票价”要求您在提交注册信息后即刻完成在线预付，若您希望在活动现场支付门票，请选择“现场票价”。
Member Ticket
Member Price RMB 2,650
Member Company Employee Ticket
Standard Price RMB 3,650
Non-Member Ticket
Standard Price RMB 4,650

Registration

  • All registrations shall be made online before the session. For full-day sessions, payment also shall be made before the session.
  • For half-day sessions, AmCham Shanghai members are eligible to attend free of charge with Training Credit*; AmCham Shanghai members without Training Credit are eligible to attend at “Member Rate”; Employees who work at AmCham Shanghai member companies are eligible to attend at "Employee Rate".
  • For full-day sessions, 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”.
  • Limited spaces are available and attendance will be given on a first-come, first-served basis.
  • Members please bring your membership card and non-members bring your business card upon check-in at the training session.
Walk-in and Cancellation Policy
  • This session requires confirmation of attendance in advance. If you attend this session without prior registration, you will be charged an RMB50 "walk-in" fee as member and RMB100 as employee.
  • Cancellation: If you need to cancel your registration for a half-day session, please notify Ivette Corominas at (86 21) 6279 7119 ext. 5671 or email ivette.corominas@amcham-shanghai.org no less than 24 hours in advance. If you need to cancel your registration for a full-day session, please notify Ivette Corominas at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.
  • To ensure that you have a seat, please come to the session on time. Open seats will be released to other guests 15 minutes after the session starts.