This is a past event. Registration is closed. View other AmCham Shanghai events.

Home

Beginning a new job that requires advanced Excel skills? This is an activity-based workshop that will cover advanced Excel features and commands that you can use at work.


您是否面临这样的挑战:需要掌握更高级的Excel应用技巧,以应对一项新的工作任务?大量的动手实践活动,丰富的实战经验技巧,涵盖多项Excel关键技术。没错!这就是本课程的魅力所在,帮助参与者拓展对Excel惯有的认识和了解,更上一层楼。

Session Outline

Advanced Cell Formatting

  • Applying Functions(COUNTIF, AND, OR)to Conditional Format
  • Highlighting Duplicates in Column


Must Know Functions

  • Date and Time Functions, Logical Functions, Lookup Functions, Statistical Functions & more.


Digital Dashboard

  • Knowing Digital Dashboard Report Design Concept
  • Advanced Formulas & Techniques.


Sorting & Filtering

  • Computed Criteria Examples, Finding the Unique Values


Pivot Table

  • Calculated Fields and Items
  • Grouping Dates/Numeric Items
  • Multiple Consolidation Ranges


More on Excel Charts

  • Combination Charts
  • Waterfall Charts Explained


Go-seek, Scenario & Solver


Introduction to Excel Macros

  • What is a Macro?
  • Recording a Macro for Querying Data, Synchronizing Pivot Tables
  • Forms(Button、Combo-Box)

本课程面向商业数据分析人士,旨在帮助用户为实现专业分析做好技术准备。


单元格格式高级设置


  • 条件格式中常用的函数
  • COUNTIF, AND, OR
  • 高亮显示重复数据 


必备常用函数


  • 时间、日期类函数
  • 逻辑函数
  • 查找函数
  • 统计函数
  • 其他常用函数


构建数字仪表盘报表


  • 报表设计思路与理念
  • 向仪表盘添加微型图表
  • 向仪表盘添加数据有效性
  • 添加常用函数(VLOOKUP,INDEX)
  • 高级函数、公式(数组公式)


排序筛选

    

  • 含计算公式的条件区域
  • 查找不重复的数值记录


数据透视 


  • 添加计算字段、计算项
  • 对数字、日期进行分组
  • 多重数据区域汇总合并


Excel高级图表

    

  • 创建多类型组合图
  • 创建叙述型瀑布图
  • 创建双坐标轴图表


目标求解、方案分析及规划求解


Excel宏


  • 什么是宏,它能实现什么?
  • 录制宏,实现按照条件查询
  • 录制宏,实现同步多透视表
  • 常用窗体控件(按钮、组合框等)
Who should attend?

Experienced Excel users who need to get their Excel skills up to speed for reporting and analysis.


具备Excel先前使用经验,期望进一步优化汇总分析技能,快速提升制作报告水平的用户。


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

Refreshments will be served during the coffee break for the attendees. Lunch at a nearby restaurant is also included with the ticket price.

Speakers

  • 胡芸芸 (易迪思金牌讲师 微软认证讲师(MCT) 微软认证OFFICE专家(MOS) 微软认证技术专家(MCITP) 《PPT变形记—从低质到高质呈现的华丽转变》作者)

    胡芸芸

    易迪思金牌讲师 微软认证讲师(MCT) 微软认证OFFICE专家(MOS) 微软认证技术专家(MCITP) 《PPT变形记—从低质到高质呈现的华丽转变》作者

    Read Bio

Tickets

A prepayment is required for all full-day training sessions. 

Member Ticket
Member Price RMB 2,650
Member Company Employee Ticket
RMB 3,650
Non-Member Ticket
RMB 4,650
Member Ticket + Redeem 500 RMB Voucher

This ticket is only eligible for members who have a RMB 500 voucher for FULL-DAY TRAININGS. Failure to present the voucher will result in paying the full price for the session.

If you have any questions about this ticket, please contact ivette.corominas@amcham-shanghai.org

Member Price RMB 2,150
Member Company Employee Ticket + Redeem 500 RMB Voucher

This ticket is only eligible for member company employees who have a RMB 500 voucher for FULL-DAY TRAININGS. Failure to present the voucher will result in paying the full price for the session.

If you have any questions about this ticket, please contact ivette.corominas@amcham-shanghai.org

RMB 3,150

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