Home

This one day course is designed for Excel users whose job primarily involves summarizing, reporting, analyzing data and building analytic models. Xue Zheng will bring us an acclaimed course with examples that make concepts easier to master. Going beyond simple tables and charts, you will learn to use advanced excel functions and data analysis tools, such as what-if analysis, solver, etc. With these powerful tools, you’ll be more productive than you’ve ever dreamed!
  1. 数据处理基本流程和注意事项
  2. 数据的收集和整理
    • 多种来源导入数据
    • 处理不合格的数据格式（数据有效性）、重复数据
    • 排序、筛选的特殊应用
  3. 数据的快速统计与分析
    • 灵活运用数据透视表构建报表
  4. 利用函数进行统计分析和报表制作
    • 统计函数的学习和应用（SUM、SUMIF、COUNT、COUNTIF、AVERAGE、AVERAGEIF 等）
    • 查找引用函数的学习和应用（VLOOKUP 等）
    • 逻辑函数的学习和应用（IF、AND、OR 等）
  5. 数据信息的呈现
  6. Excel 报表的发布准备

Session Outline

  • Master the proposed data source formats in data processing; correct the error habit of establishing the data form.
  • Learn and master the practical function of enhancing the efficiency of processing data and operation skills.
  • Master the tools of fast making reports and the popular data analysis function; improve the efficiency of data analysis.
  • Find the suitable data presentation and performance practices; highlighting information of data; improving the quality of work reports.
     
  • 掌握数据分析中的理想数据源格式，改变建立数据表格的错误习惯
  • 学习并掌握能提升数据处理效率的实用功能并掌握操作技巧
  • 掌握快速进行报表制作的重要工具和常用数据分析函数， 提高数据统计分析效率
  • 找到适合自己的数据呈现方式和表现手法，突出数据信息， 提高工作报表质量 
Who should attend?
People who need to improve their Excel-using level, and those looking to improve the efficiency of data processing (Mid-Senior course)

Agenda

8:45 AM - 9:00 AM
Registration
9:00 AM - 10:30 AM
Morning Session
10:30 AM - 10:45 AM
Coffee Break
10:45 AM - 12:00 PM
Morning Session
12:00 PM - 1:00 PM
Lunch
1:00 PM - 3:30 PM
Afternoon Session
3:30 PM - 3:45 PM
Coffee Break
3:45 PM - 5:00 PM
Afternoon Session
5 PM Session Ends

Speakers

  • Zheng Xue

    Zheng Xue

    易迪思Office金牌讲师、清华大学 MBA 班特邀培训师
    微软Office最有价值专家（MVP）、微软认证技术专家（MCP）
    他有8年专业培训师经验，曾服务近百家国内外知名企业、国家机关单位及高等学府。每年授课超过百场，受到各级学员的一致好评与爱戴。他也曾担任微软内部员工 Office 办公技能培训项目培训师及项目负责人，从Office 软件制作厂商系统 Office 的应用价值和使用技巧。对于 Office 办公软件培训有丰富的课程设计及授课经验，擅长为企业定制培训课程和搭建培训体系。

    view more

Tickets

Member Ticket
Member Price RMB 2,650
Employee Ticket
Standard Price RMB 3,650
Door 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 Kelly Deng at (86 21) 6279 7119 ext. 4580 or email Kelly.deng@amcham-shanghai.org no less than 24 hours in advance. If you need to cancel your registration for a full-day session, please notify Kelly Deng 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.